Can we parametrize the values of IN statement.
Ex.
Inside parameter file:
Parameter='A','B','C'
Inside Code:
IN (INPUT_CHARACTER, $$Parameter)
- 2 Answers
- 5003 Views
- Cognizant, IBM, I also Faced
- E-Mail Answers
Answer Posted / tabish khan
Frankly i dont know the answer but i told the interviewer that
we cannot do this.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
Do we need an ETL tool? When do we go for the tools in the market?
How many steps etl contains explain with example?
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.
Explain me ETL project architecture in Detail?
Explain about power designer data modeling software?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
how do u implement configuration management in Informatica?
What is etl process?
if i have a query as flat file how can we load data to target table
how do u really know that paging to disk is happening while u are using a lookup transform?
how would u estimate the size of Aggregator transform data and index cache?
How to increase performance without changing anything in mapping.( In prod)
what is the difference steps for data modeling?
