in realtime which situations u can use unconnected lookup
transformation
Answers were Sorted based on User's Feedback
Answer / amedela chandra sekhar
When we want to get single return port and also we can call
this any where in the mapping.
Is This Answer Correct ? | 11 Yes | 1 No |
Explain sql transformation in script mode examples in informatica
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.
What is session task and command task?
What is a rank transform?
Can we run session without using workflows?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 Answers Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,
What all are steps in up gradation of Informatica server?
What are the connected or unconnected transforamations?
Explain about perform recovery?
what are factless facts? And in which scenario will you use such kinds of fact tables.