Howmany ways yoU can update a relational source defintion
and what are they?
Answer / swetha
Two ways
1. Edit the definition
2. Reimport the defintion
| Is This Answer Correct ? | 2 Yes | 0 No |
I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?
How to get EVEN & ODD numbers separately?
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?
What is predefined event?
How to delete duplicate row using informatica?
how to we create datamart?
Major difference between SQL override and Lookup Sql override
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
What are the different types of Type2 dimension maping?
what is $$$$?
Examples of Fatal & Non-Fatal error?