what is lookup ?6 5281
what is the flow?1 2493
In update strategy target table or flat file which gives more performance ? why?7 12529
Why touse stored procedure in ETL Application?2 5649
What is critical mapping?1 4845
How to view and Generate Metadata Reports?1 3059
what is the gap analysis?1 4781
How to recover sessions in concurrent batches?3 8382
what are the different types of transformation available in informatica and what are the mostly used ?
Enterprise data warehouse your projects phase by phase explain?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Can we change Dynamic to Static or Persistent cache? If so what happens?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
what is index?how it can work in informatica
What are the new features of Power Center 5.0?
What is the meaning of up gradation of repository?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
my source is junk data how will u remove that junk data by using unix please any one replay me
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab