My source table having some records ,i want load 1st record
and last record into one target?
- 3 Answers
- 8882 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / kiran
take two rank transformations and take reusable sequence
generator connect the next value to both rank transformations
and in the rank transformations properties for the first one
take top and number of ranks as 1 for the second take bottom
and number of ranks 1 at the last take two instances of tgt
connect the ranktrans to two instances
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What happens when a session fails and you click on recover?
Suppose we do not group by on any ports of the aggregator what will be the output?
Differentiate between Load Manager and DTM?
Explain the scenario which compels informatica server to reject files?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Tell me about Propagate functions in informatica
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How big was your fact table
What is the need of etl tools?
Define mapping and session?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Where is metadata stored?
