My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
2 6781I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
3 13675while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile
2 6825Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.
1 6847if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
2 6713Post New Informatica Questions
What will be the approach?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
When do you use sql override in a lookup transformation?
How to do unit testing in informatica? How to load data in informatica ?
What is an Integration service in Informatica?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Define sessions in informatica etl?
What are the tuning techniques you applied during your last project
Reusable transformation and shortcut differences
What is informatica powercenter repository?
Enlist the tasks for which source qualifier transformation is used.
Explain load alternative records / rows into multiple targets - informatica
How to load last n records of file into target table - informatica
what is degenerated dimension?
How to update source definition?