in unconnected lookup , what are the other transformations ,
that can be used in place of that expression transformation ?
- 9 Answers
- 19202 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / vishnu_kr
HI, UZVAL
PLEASE STATE HOW DO U USE UNCONNECTED LOOKUP FROM A SOURCE
QUALIFIER
IN MY KNOWLEDGE WE CAN'T USE U/C LKP IN SQ BUT WE CAN USE
IT IN OTHER TRFNs LIKE ROUTER, AGGR ETC.. WHERE EXPRESSIONS
EVALUATION IS ALLOWED.
PLEASE REPLY IF I AM WRONG.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Why update strategy and union transformations are active? Explain with examples.
What is the use of source qualifier?
Could you explain what is enterprise data warehouse?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is decode in informatica?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What do think which one is the better joiner or look up?
hi real timers . iam waiting for ur reply regarding ETL TESTING
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Which means the first record should come as last record and last record should come as first record and load into the target file?
While migrating the data from one environment to another environment how would you manage the connections?
How to update source definition?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
