Explain the use of aggregator cache file?
No Answer is Posted For this Question
Be the First to Post Answer
State the differences between sql override and lookup override?
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?
i have source in oracle 10g,oracle 8i how will u take the data from two sources
Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks
why we r using presql&postsql in source qualifier?
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
What is a candidate key?
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
How to delete first 3 rows & last 3 rows in target table in informatica
1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??