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 5769I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
3 11917while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile
2 5758Hi 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 5749if 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 5785Post New Informatica Questions
What if the source is a flat-file?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How to start a workflow using pmcmd command?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What do you understand by term role-playing dimension?
What all join we can perform in LOOKUP transformation?
What is the need of an ETL tool?
Define the various join types of joiner transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Explain what are the different types of transformation available in informatica.
what is INFORMATICA TESTING process
To import the flat file definition into the designer where should the flat file be placed?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is workflow? What are the components of workflow manager?