I have Employee table, 10 cols are connected to next
transformation, only 4 cols are selected in SQL override.
What would be passed to next col.
- 5 Answers
- 13855 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / dl
few more addition to the above answer......
If you ignore to validate sql query in source qualifier
transformation mapping validates but at workflow level
sessiom fails with as error"variable not in select
list......."
| Is This Answer Correct ? | 19 Yes | 1 No |
Post New Answer View All Answers
What is a shortcut and copy in Informatica and how two are different with each other?
What is a router transformation?
How can we use mapping variables in informatica?
What is the use of source qualifier?
What is standalone command task?
What is rank transformation in informatica
Explain sql transformation in script mode examples in informatica
What is sorter transformation?
Define mapping and session?
What is domain and gateway node?
What's the layout of parameter file (what does a parameter file contain?)?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
How union transformation is used?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Explain the types of lookup transformation?
