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?
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
Explain the different kinds of facts.
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is the fact table?
How are the sources and targets definitions imported in informatica designer?
What are the different types of olap? Give an example?
What does update strategy mean, and what are the different option of it?
What are junk dimensions?
Whats there in global repository
What is sorter transformation?
Under which circumstances, informatica server creates reject files?
What do mean by local and global repository?
Briefly describe lookup transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is the commit type if you have a transaction control transformation in the mapping?
Why do you use Mapping Parameter and mapping variable?