when we use dynamic lookup,if condition matches what will be
the o/p?
Answers were Sorted based on User's Feedback
Answer / sujana
it updates the row in the cache r leaves it unchanged
Is This Answer Correct ? | 12 Yes | 0 No |
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
How to differentiate between the active and passive transformations?
Can we insert and update a target table without using update strategy transformation?How?
Where do you create/define mapping parameter and mapping variable?
What is the difference between lookup override and souce qualifier override ?
How to eliminate 1st and last rows from the source and load the inbetween rows.
Can you use one mapping to populate two tables in different schemas
How do you remove duplicate records in informatica?
How are indexes created after completing the load process?
Can you access a repository created in previous version of Informatica?