What is difference between a connected look up and
unconnected look up?
Answer Posted / mln
connected look up is not reusable and only one output port
are return port will be there at a time and this is more
faster than connected.
| Is This Answer Correct ? | 4 Yes | 44 No |
Post New Answer View All Answers
Design a mapping to load a target table with the following values from the above source?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How do you update the records with or without using update strategy?
Explain what are the different versions of informatica?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What are the different transaction levels available in transaction control transformation?
How can we delete duplicate rows from flat files?
What are the types of caches in lookup?
What are the mapping parameters and mapping variables?
What are the types of data warehouses?
What is the difference between router and filter?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What do you mean by worklet?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?