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 7934I 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 8336Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
CSC,
10 34489I still need further explanation about the difference between active and passive transformation with some examples.Thank You
5 7650What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
7 18734I 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 6570Hi 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 7267How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).
5 10274Can 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 7790Post New Informatica Questions
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What are the informatica performance improvement tips
Separate from an archive server and a powerhouse?
What are the different ways to implement parallel processing in informatica?
What will be the approach?
Explain scd type 3 through mapping.
What is the way to execute pl/sql script using informatica mapping?
What is pmcmd command?
How to load the data from a flat file into the target where the source flat file name changes daily?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
can anyone explain me about retail domain project in informatica?
What is workflow? What are the components of the workflow manager?
How might one distinguish in the case of mapping is right or not without associating session?
How many input parameters can exist in an unconnected lookup?