Can we parametrize the values of IN statement.
Ex.
Inside parameter file:
Parameter='A','B','C'
Inside Code:
IN (INPUT_CHARACTER, $$Parameter)

Answer Posted / pondara shivaji

Prankly asking have u got selected interview by answering
above question.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between Data Warehousing and Data Mining?

557


what is dynamic insert?

1719


Explain etl mapping sheets?

672


how do u really know that paging to disk is happening while u are using a lookup transform?

2055


what is the difference between cubes and package in cognos

4536






Explain about the data integration suite features?

479


Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1643


How many steps etl contains?

537


What is etl process. How many steps etl contains explain with example?

523


How to fine tune mappings?

570


What are the differences between sql override and update override?

587


what is the main role of FI on business

1636


What is virtual Data Warehousing?

560


When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

547


A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

1834