Can we use different lookup tranformations for a same
lookup table (lookup condition may or may not be same)with
different output ports? How the cache files will be
affected? Please clarify..
Answer Posted / sivakumar
cache files woll be destoryed
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What do mean by local and global repository?
What is sorter transformation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What are pre and post-session shell commands?
What is a repository manager?
What is source qualifier transformation in informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are multi-group transformations?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
If informatica has its scheduler why using third party scheduler?
What is the session task and command task?
What is the difference between source qualifier transformations source filter to filter transformation?
What is the surrogate key?
Explain the use of aggregator cache file?