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.
Can informatica load heterogeneous targets from heterogeneous sources?
Can we override a native sql query within informatica?
Where is metadata stored?
How do we call shell scripts from informatica?
Where do we use mapping variables in informatica?
How can we use mapping variables in informatica?
How can we use mapping variables in informatica? Where do we use them?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Difference between nodup and nodupkey options?
Explain bmdp procedure?
What makes sas stand out to be the best over other data analytics tools?
What will calendar procedure do?
Do you know the features of sas?