Interested to Buy Any Domain ? << Click Here >> for more details...
How to load only the first and last record of a flat file into
the target?
- 3 Answers
- 9915 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / yaseen
After SQ place 2 Rank T/R and a reusable sequence generator T/R having start value 1. In 1st Rank give the top 1 and in 2nd Rank set bottom 1
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What is the cumulative sum and moving sum?
how to load rows into fact table in data warehouse
What are session parameters ? How do you set them?
What is the function of aggregator transformation?
how to load dimension table and fact table. plz tell me the steps.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
can we override a native sql query within informatica? How do we do it?
How do we call shell scripts from informatica?
Explain the different lookup methods used in informatica?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How do you convert single row from source into three rows into target?
What are the different lookup cache(s)?
Enlist some properties of sessions.
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
During the running session, output files are created by informatica server. Enlist few of them.
