In a table, 4 person having same salary. How to get Third
person record only?
Answer Posted / hardeep
We can use Rank Trx, Select "salary" as Group by port and select "Date" or "Emp_id" as Rank Port and then Filter out records with Rank=3 thru Filter Trx.
Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is the use of target designer?
What if the source is a flat-file?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What do you understand by SOA of Informatica?
Briefly explain the aggregator transformation?
permutations of mapplet
Can informatica load heterogeneous targets from heterogeneous sources?
What is a shortcut and copy in Informatica and how two are different with each other?
How to update a particular record in target with out running whole workflow?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
If informatica has its scheduler why using third party scheduler?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?