Answer / kishore

We can use union all Transforamtion .if the struture is
same....

Answer / arjun

not possible

Answer / raja

we use the union transformation,but metadata must be same
then it is possible to join the two hetrogenous tables

Answer / aakansha

It is not possible to join a flat file and relational source
without joiner/lookup. Source qualifier is used for
heterogeneous source...means source belongs to same
database...in the ur case flat file and relational source
not belong to same database so...we cant join it into SQ.

Answer / ik

its possible by using 2 different sessions and connecting them in a single workflow

Answer / anoymous

Not possible to join flat file without transformations
however relational sources can be joined in source qualifier

ex: select * from emp,dept;

Answer / rahul

no its not possible.

sql trans is used to connect hetro src but when you drag
flat file n connect to Sq t/r , all properties expect
tracing level evey thing will be disable.

SO WE CANT JOIN

Answer / abhishek upadhyay

Hi All,

Whatever you all have mentioned is true.....that the source
qualifier joins only homogenous tables and as per the
question we can not use a joiner.

But,
If it is a normal join we can do this by using lookup
transformation between those two files.......
In case of full outer or left outer or right outer joins
this will not work..Thanks a lot.

Answer / charan

Hi,
I know this is possible but not sure how.. SQ is used for
Homogenius sources. Anyone else please try to get a
positive answer on this one.

Answer / mallikarjun

Hi Ajith,
It is Possible to Join data from a flat file and a relation
source, this can be done with the help of a joiner
transformation where you have to map one input port to the
relation data column and other to the flat file coumn and
give the joiner condition.. Hope this will help you or drop
a mail...


Thanks & Regards,
Mallikarjun

What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,

Explain sessions?

0 Answers  

Under what condition selecting sorted input in aggregator may fail the session?

0 Answers  

What are the prerequisite tasks to achieve the session partition?

0 Answers  

hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me

3 Answers  

What is joiner cache?

2 Answers   TCS,

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,

COM components can be used in Informatica

0 Answers  

What is use of batch file in informatica? How many types of batch file in informatica?

2 Answers   EXL,

what are the output files that the informatica server creats during running a session?

2 Answers   CTS,

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.

1 Answers  

how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,