Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the first row without using rank t/r?
- 7 Answers
- 12685 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / gandra krishna reddy
by using first function in aggregator transformation.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is the difference between Active and Passive transformation?
What is the use of code page?
What are the static cache and dynamic cache in informatica?
Can we get 1st record through Informatica(without sequence number).
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 .
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
What is primary and backup node?
What is rank transform?
What is the use of target designer?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
what is SDLC way of code development?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Explain the features of connected and unconnected lookup.
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
