how do u get the first record from 50,000 records ?
Answer Posted / subramanyam
use rank transformation u can get it
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Explain the informatica workflow?
Explain why we use partitioning the session in informatica?
In warehouses how many schemas are there?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
permutations of mapplet
Why update strategy and union transformations are active?
What are roles and groups and benefits of using them?
How might one distinguish in the case of mapping is right or not without associating session?
Tell me about Propagate functions in informatica
Mention few advantages of router transformation over filter transformation.
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How would you copy the content of one repository to another repository?
How do you set a varible in incremental aggregation
How to generate or load values in to the target table based on a column value using informatica etl tool.