Types of error logs in Informatica?
Answers were Sorted based on User's Feedback
Answer / gm
Hi,
1. Session Log (we can set how many logs file needed)
2. Workflow Log
| Is This Answer Correct ? | 1 Yes | 6 No |
Answer / shalaka
Specifies the type of error log to create. You can specify relational, file, or no log. By default, the Error Log Type is set to none.
| Is This Answer Correct ? | 0 Yes | 8 No |
What is aggregator transformation in informatica?
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
what is materialized view?
What is decode in informatica?
Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.
why u go for dimensions ?
write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
HOW TO GET THE LATEST DATA IN SCD ?
Explain the shared cache and re-cache?
What are the mapping paramaters and mapping variables?
What is an MDDB? What is the difference between MDDBs and RDBMSs?