Answer Posted / mln
as of my knoledge metadata is data about data or structure
of the database objetcts like tables or indexs etc.
no idea about syscatlog
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what is the size of your data warehousing?
How many number of sessions can one group in batches?
if we have a delimiters at unwanted places in a flat file how can we over come those.
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 ?
What are mapplets? How is it different from a Reusable Transformation?
Define pmcmd command?
what is the Default Source Option For Update Strategy Transformation?
What are the data movement modes in informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Explain about Informatica server process that how it works relates to mapping variables?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the tasks that source qualifier perform?
How do you promote a non-reusable transformation to reusable transformation?
What is the sql query overwrite in source qualifier in informatica
How do you load unique records into one target table and duplicate records into a different target table?