What is full load & incremental or refresh load?
No Answer is Posted For this Question
Be the First to Post Answer
indatastage 8.1 surrgoate key generates seqences numbers write but there is limite value i want to reset the seqence after gettting some highest value like i want o/p like this 1 2 3 4 5 .............10000 1 2 3.........10000
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
What is etl process? How many steps etl contains?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what are the session parameters? How do u set them?
What is virtual Data Warehousing?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
what is data modeling?
what are variable ports and list two situations when they can be used?
Mention few test cases and explain them?
Can u access a repository created in previous version of Informatica?
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)