Qn1 What is the difference in Connected and Unconnected Lookup?
Qn2 :Why Unconnected lookup is used or In which scenario unconnected lookup is used
1. When Lookup is used more than one time in mapping
2. The benefit of an unconnected lookup is that you can do conditional lookups (using IIF,DECODE, etc.). In other words, you can control when the lookup is used with in unconnected lookup.
Example iif(isnull(prod_type),’x’, lkp.p_name(:ptypecode))
3. It provides reusability
For the example
Code Description: Nurse practitioner
Code Description: New Jersy
Suppose in the mapping expression you need to get the description for different ports from code table
When it is getting the description for Customer type system it is used like lkp.get_code_val(‘EDW’,'CUST_TYPE',’NP’)
When it is getting the description from IMS system it is used like lkp.get_code_val(‘EDW’,'STATE_CODE',’NJ’)
4. It is used is slowly changing dimensions
Checking the record exists or not then decide insert or update
Q3:Using indirect method we can load files with same structure. How to load file name in the database.
In database want to load the file name
This can be done by enabling CurrentlyProcessedRow
Do this in the source analyzer while create the source definition
Then this Currently ProcessedRows column will be enabled
Qn4:Sequence Generator or Update Strategy transformation can not be used in upstream from a Union transformation.Any reason behind this
Qn5 What are the row and Column Indicator
Bad files have the row and columns indicator RowIndicator Meaning Rejected By
column indicators, are as below: