How to generate or load values in to the target table based on a column value using informatica etl tool.
704While importing the relational source definition from the database, what are the metadata of source that will be imported?
907
Can you explain model durability?
Briefly state different between data ware house & data mart?
What is the max core of a component?
Describe what the SQL Server tempdb and tlog files are used for?
Fact table is in normalized or de-normalized form?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Where is teradata rdbms used?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Differentiate between datastage and informatica?
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
In SAS explain which statement does not perform automatic conversions in comparisons?
What is an Integration service in Informatica?
How would you join a node to the already existing domain?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
What are the six data process products of ab initio (architecture of ab initio)?