source target
--------- --------
name no sal name no sal max_sal
r 10 1000 r 10 1000 3000
y 20 3000 y 20 3000 3000
Answer Posted / james
Hey Babu,
I've tried your query.
It's not working for me.
Please double check it.
And u said my query doesn't work.
It works absolutely fine for me.
Please let me know where my went wrong.
Waiting for your reply.
-James
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to load the data from people soft hrm to people soft erm using informatica?
How big was your fact table
Can we create two repositories on same database instance in oracle?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What are the main issues while working with flat files as source and as targets ?
Parameter and variable differences
What are the basic requirements to join two sources in a source qualifier transformation using default join?
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 ?
I have a flat file, want to reverse the contents of the flat file
What is a filter transformation and why it is an active one?
Does an informatica transformation support only aggregate expressions?
What is the difference between router and filter?
What is the use of code page?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab