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??
KPIT,
1 7232I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
CSC,
3 7066Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
CSC,
10 31528I still need further explanation about the difference between active and passive transformation with some examples.Thank You
5 5902What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
7 15994I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?
3 5416Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
3 6033How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).
5 8498Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
2 6815Post New Informatica Questions
What is the meaning of up gradation of repository?
Explain the features of connected and unconnected lookup.
What are the differences between a connected lookup and unconnected lookup?
What is a grid in Informatica?
How to load the data from a flat file into the target where the source flat file name changes daily?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Is it possible to revert a global repository to local one and why?
What is a shortcut and copy in Informatica and how two are different with each other?
How to update source definition?
Enlist the differences between database and data warehouse.
What is rank transform?
explain one complex mapping with logic? sales project?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is the sql query overwrite in source qualifier in informatica
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?