Interested to Buy Any Domain ? << Click Here >> for more details...
The Source coloumns are A,B,C with data row1- 10,20,30 row2-
40,50,60 row3-70,80,90 and so on. In the target I want one
coloumn with the following data, Coloumn-X, row1-10,row2-
20,row3-30,row4-40,row5-50 and so on. How to achieve this?
- 3 Answers
- 7921 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / babu
Hi All,
By using Normalizer Transformation we will achive this.
Mapping:
========
Src==>SQ==>Nrm(Normalizer)==>Srt(sorter)==>Trg
Nrm:Column(Occerence 3)
Column1 (inputport)
Column2 (inpuport)
Column3 (inputport)
Column (outputport)===> Srt ==>Trg
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / swapnil
no need to use normalizer here, take 3 expression and 3
instance of target.
Create 3 expression transformations exp_1,exp_2 and exp_3
with 1 port each. Connect col1 from Source Qualifier to
port in exp_1.Connect col2 from Source Qualifier to port in
exp_2.Connect col3 from source qualifier to port in exp_3.
Make 3 instances of the target. Connect port from exp_1 to
target_1. Connect port from exp_2 to target_2 and connect
port from exp_3 to target_3.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / kuldeep singh rathore
Create 3 expression transformations exp_1,exp_2 and exp_3
with 1 port each. Connect col1 from Source Qualifier to
port in exp_1.Connect col2 from Source Qualifier to port in
exp_2.Connect col3 from source qualifier to port in exp_3.
and we merge all output of all 3 expressions by UNION trans
and direct load to tgt from union
| Is This Answer Correct ? | 0 Yes | 0 No |
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
What the difference is between a database, a data warehouse and a data mart?
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
what r the values tht r passed between informatics server and stored procedure?
During the running session, output files are created by informatica server. Enlist few of them.
How to Create a folder using pmrep command?
how can we load starting with 11th record of a table from source to target
how many types of dimensions are available in informatica?
How do you implement scheduling in Informatica?
Teradata 
