How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
CTS,
Informatica 1119What 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 ?
CTS,
Informatica 1176how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
CTS,
Informatica 1245I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
CTS,
Informatica 1199What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
CTS,
1 Informatica 1569
Question { 12105 }
What is difference between partioning of relatonal target
and partitioning of file targets?
Answer
Is This Answer Correct ? | 1 Yes | 0 No |
Three date formats are there . How to change these three into
One format without using expression transformation ?
Answer
Is This Answer Correct ? | 0 Yes | 0 No |
Question { Logica CMG, 9888 }
How do schedule a workflow in Informatica thrice in a day?
Like run the workflow at 3am, 5am and 4pm?
Answer