-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 are the issues you have faced in your project? How did you overcome those issues?
Enterprise data warehouse your projects phase by phase explain?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
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. ?
tell me 5 session failure in real time how can you solve that in your project?
explain about unit testing? in real time?
wf dont have integration severances how you can run?
explain one complex mapping with logic? sales project?
Performance tuning in UNIX for informatica mappings?
How to do the error handling of if ur source is flatfiles?
Did u used latest transformations of 8.6.0? for what?
Can we change Dynamic to Static or Persistent cache? If so what happens?
