i have n number of records in my source, i want first and
last record to my target. how can u implement this scenario .
Answer Posted / srinivas bolusupati
Use sequence generator t/r and give the nextval link
to 2 rank transformations, 1st one with top1 and 2nd one with bottom1 and connect them to 2 instances of target..
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Write the different tools in the workflow manager?
How many dimensions are there in informatica?
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 workflow monitor?
Differentiate between a database and data warehouse?
What are the components of Informatica? And what is the purpose of each?
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
What are the advantages of informatica?
What are the reusable transformations?
Why sorter is an active transformation?
can we override a native sql query within informatica? How do we do it?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is union transformation in informatica?