Interested to Buy Any Domain ? << Click Here >> for more details...
i have oracle table A and target B. i don't know how many
records. i want get get last record in table A as first record
in target table B. write a sql query?
- 7 Answers
- 10867 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / priyank
In Informatica, make table A as Source and follow the below
mapping:
SRC_A --> AGG --> TGT_B
AGG: Do not check any of the columns for group by and pass
the output to target B. In this way, only the last row will
be passed through.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Differentiate between sessions and batches?
How to convert multiple rows to single row (multiple columns) in informatica
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What are some examples of informatica etl programs?
Explian the Process of deployment groups in informatica
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How to load last n records of file into target table - informatica
Explain in detail about scd type 1 through mapping.
explain abt ur project architecture?
Where do we use mapping variables in informatica?
What are the components of Informatica? And what is the purpose of each?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How to create the source and target database connections in server manager?
How do you convert single row from source into three rows into target?
What is union transformation?
