In Flat file
Input is
A
B
C
I need output like this
A
A
A
B
B
B
C
C
C. How will u achieve this?
Answer Posted / ankur saini
to make this simple from sq--take 3 expressions---add union
to take data from theses three expressions
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
scenario where i can use only concurrent execution of workflow.
What is the need of an ETL tool?
How can you increase the performance in joiner transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How many input parameters can exist in an unconnected lookup?
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 ?
Performance tuning( what you did in performance tuning)
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Explain the difference between mapping parameter and mapping variable?
What is the scenario which compels informatica server to reject files?
How an expression transformation differs from aggregator transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Explain pmcmd command usage in informatica
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Please let me know how to make Data masking in informatica..