Which gives the more performance when compare to fixed width and delimited file ? and why?
HP,
3 12331which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
TCS,
7 11514how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
5 18738suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how
TCS,
7 11550sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it
1 3803Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
1 4127hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...
1537hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com
1631Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
6 15371Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
1 4700Post New Informatica Questions
What differs when we choose the sorted input for aggregator transformation?
What are the static cache and dynamic cache in informatica?
what are 3 tech challenges/ common issues you face?
What is the need for an etl tool?
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 lookup transformation?
How to convert multiple rows to single row (multiple columns) in informatica
Different qualification between a related rotate toward the sky and isolates look upward?
How to improve the performance of a session using sorter transformation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is informatica etl tool?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
can we override a native sql query within informatica? Where do we do it? How do we do it?
Enlist the various types of transformations.
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 ?