Interested to Buy Any Domain ? << Click Here >> for more details...
Is scd logic we have lookup right to compare the values with
source and target,instead of lookup can u have any
transformation or any way to do this?
- 2 Answers
- 6112 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / naga
We can write Left outerjoin with the target in Source
Qualifier itself or if ur src is file & target is Table
then using Joine(Left outer) can get the new rows loaded
into target
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / itsranjan
Hi, Joiner transformation can do the same job what lookup
does in SCD.
| Is This Answer Correct ? | 1 Yes | 2 No |
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
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.
case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,
What are the types of caches in lookup?
What is a shortcut and copy in Informatica and how two are different with each other?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
if i have a delimited file as source so how can we seperate this file into three diff targets?
What are the types of maping in Getting Started Wizard?
Differnce between filter and router?
How many joins in Informatica
Can anyone please distinguish what is Inner join and Outer join
Teradata 
