Answer / zer0

Create the mapping as below:

EXP1 ---> SRT1
/ \
Src --> Router Joiner ---> EXP3 ---> Targ
\ /
EXP2 ---> SRT2

Router: Filter on the basis of gender. All records with
gender male wil go into EXP1 and the records with gender
female will go into EXP2.
In EXP1 and EXP2, create a variable dummy port (Seq_Var)
with value Seq_Var+1 and an output port Seq_Out (value-
Seq_Var).
Pass the name and sequence ports from EXP1 and EXP2 to SRT1
and SRT2 (sorter) respectively.
In SRT1 and SRT2, sort on the basis of sequence.
In Joiner, use 'Full Outer Join' and keep 'Sorted Input'
checked in properties.
Pass the male name values and female name values from
joiner to EXP3 (Gather all the data). Pass all the data to
Target.

Answer / chiky

map1
map1
1.source
2.sorter
3.filter ( gender = male)
4.connect to male_name column in target

map2
1.source
2.sorter
3.filter( gender = female)
4.connect to female_namw column in same target)

target load plan 1,2
start the load.

Answer / vicky

select name as male from table where gender= 'male'
union select name as female from table where gender='female'

Answer / rakesh ameta

select male,female from
(select row_number() over (order by (select 1)) as ID,names as male from gen where genders='male') a
FULL join
(select row_number() over (order by (select 1)) as ID,names as female from gen where genders='female') b
on a.id=b.id

I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,

---

What are the differences between joiner transformation and source qualifier transformation?

0 Answers   Informatica,

---

Why you use repository connectivity?

3 Answers   Yash Technologies,

---

How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,

---

What are the different options used to configure the sequential batches?

2 Answers   Wipro,

---

---

What is deployment group?

0 Answers  

---

what is lookupoverriding?

1 Answers  

---

What are ETL Tools?

0 Answers   Informatica,

---

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.

0 Answers  

---

how do u get the first record from 50,000 records ?

10 Answers   TCS, UBS,

---

what are objects in data warehouse?

2 Answers   Mind Tree,

---

Can you copy the session to a different folder or repository?

2 Answers  

---