What are the validations that you can perform in oracle and
in informatica ?
Advance Thanks
- 0 Answers
- 1849 Views
- Puma, I also Faced
- E-Mail Answers
Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
State the differences between sql override and lookup override?
How to go to the older version for a mapping?
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
How union transformation is active ?
Explain how many types of dimensions are available in informatica?
Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva
what is incremental aggregation ,with example?
Explain load alternative records / rows into multiple targets - informatica
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
Teradata 
