S1 is having 1 lakh records and s2 is having 100 records, s2 should compa

Advertise your Business Here

Refer this Site

Login | Sign Up


	SiteMap shows list of All Categories in this site.

Categories >> Software >> Data Warehouse >> Informatica

Teradata Interview Questions

Business Objects Interview Questions

Cognos Interview Questions

Informatica Interview Questions

Crystal Enterprise Suite Interview Questions

Actuate Interview Questions

Ab Initio Interview Questions

Data Stage Interview Questions

SAS Interview Questions

Micro Strategy Interview Questions

ETL Interview Questions

Data Warehouse General Interview Questions

Question

S1 is having 1 lakh records and s2 is having 100 records, 
s2 should compare  s1 if emp no is same data should be 
updated if not their it should insert the data.what are the 
transformation used?

Question Submitted By :: Lakshmi

I also faced this Question!!

Rank

Answer Posted By

Re: S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

Answer
# 1

In this scenario generally using the two transformations
(Joiner&UpdateStrategy Tx) if S1 and S2 are different 
sources or Flat files; 
  Else if both are in same sources as of relational then 
join it in SourceQulaifier Tx itself in this case no need 
for Joiner tx.

1) Joiner Tx will join the S1 and S2 by using common 
fields; here S2 is the Master table.

2)In UpdateStrategy Tx. Condition is like IIF
(s2.empno=s1.empno,1,0)

Is This Answer Correct ?

0 Yes

0 No

Madhava

Question	Asked @	Answers
Other Informatica Interview Questions


Discuss the advantages & Disadvantages of star & snowflake schema?		2
What are the Differences between static cache and dynamic cache?		1
What is the filename which you need to configure in UNIX while installing infromatica?	Accenture	2
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?		6
How do you handle decimal places while importing a flatfile into informatica?		1
can we generate reports in informatica ? How?		2
what are the transformations that restricts the partitioning of sessions?		1
what is confirmed dimension?		4
What is the use of incremental aggregation?		1
How to send duplicates to one target and unique rows to one target?target is empty	Wipro	3
Describe two levels in which update strategy transformation sets?		1
If we have lookup table in workflow how do you trouble shhot to increase performance?		2
What is IQD file?		1
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.	Accenture	9
What are the types of groups in Router transformation?		1
Without source how to insert record to target?		2
if the session fails after 100 records agian we have to starts the session or we go for recovery session	TCS	2
what is lookup ?		4
How to display First letter of Names in Caps?		4
What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .		3

For more Informatica Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com