1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

If you done any modifications for a table in back end does
it reflect in informatca warehouse or maping?

Question Posted / guest

Answers were Sorted based on User's Feedback



If you done any modifications for a table in back end does it reflect in informatca warehouse or m..

Answer / deepak aggarwal

No there is no option in informatica for automatic update
of source/target/lookup/stored procedure definition from
DB/file.
Though you can compare source/target/../.. definitions from
existing DB objects and make out if informatica definitions
needs a updation.

Is This Answer Correct ?    3 Yes 0 No

If you done any modifications for a table in back end does it reflect in informatca warehouse or m..

Answer / janardhan avula

No..it could not reflect in informatica.informatica is one
of the Dynamic ETL tool using this tool we can design the
the data effectively according to business
requirement..database is different..

I though am i correct.
if u want more info mail me at avula.janardhan@gmail.com

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

How can you increase the performance in joiner transformation?

0 Answers  

what is song in infrmatica...?

0 Answers   CTS,

What is difference between a connected look up and unconnected look up?

6 Answers  

What are the mapping paramaters and mapping variables?

1 Answers  

What is source qualifier?

6 Answers   SDS,




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  

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,

What is the advantage of informatica?

0 Answers  

In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?

3 Answers   emc2,

What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,

how i will stop my workflow after 10 errors

2 Answers   HP,

What is a filter transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories