Interested to Buy Any Domain ? << Click Here >> for more details...
- Teradata (300)
- Business Objects (167)
- Cognos (423)
- Informatica (792)
- Crystal Enterprise Suite (5)
- Actuate (15)
- Ab Initio (247)
- Data Stage (356)
- SAS (530)
- Micro Strategy (244)
- ETL (215)
- OBIEE (47)
- IBM Cognos TM1 (55)
- Amazon Redshift (62)
- Data Warehouse General (578)
Explain your project of banking domian.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
How to load specific no.of records using bteq, or fastload,or multiload
What is use Array size in datastage
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is the size of database for you project?
New coloums are added in database, then how you know in report level
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
