Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
I have one scenario.. i want to insert 4 times (Duplicate)
a row in the target. Please help me .
source row: abcabc
Tgt table:
abcabc
abcabc
abcabc
abcabc
- 10 Answers
- 19587 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / anup shukla
Create router transformation with 4 different ports.
and set condition true for all the four ports.
and take it to the target from union trans.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
r u done any partitions in ur project?
tell me the rules and responsblites in our project(my project is development)
Explain the types of lookup transformation?
What is meant by LDAP users?
Enlist the tasks for which source qualifier transformation is used.
Explain sessions. Explain how batches are used to combine executions?
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.
What is informatica?
Write the different tools in the workflow manager?
Name the different lookup cache(s)?
What are the transformations that are not supported in mapplet?
What are the different types of transformation available in informatica.
What is the advantage of informatica?
Can we override a native sql query within informatica?
