Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

NTT Data,

2 5522

I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?

Cognizant, HCL,

1 7186

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

Polaris, Zensar,

5 6933

What is different between informatica version 8 and 9 version

Cognizant, IBM,

1 1934

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

Wipro,

5 8091

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

CSC, iNautix,

3 12769

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

Motorola,

2 3893

IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 4213

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

Cap Gemini, IBM,

4 10036

what is the difference between mapplet & stored procedure?

1 4230

Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin

1 3337

scenario where i can use only concurrent execution of workflow.

Cognizant,

2028

How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?

Rolta,

2 7199

How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.

Eureka Forbes,

3 10478

how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)

Cognizant, HP, TCS,

3 9765


Post New Informatica Questions






Un-Answered Questions { Informatica }

How are the sources and targets definitions imported in informatica designer?

183


Explain lookup transformation source types in informatica

179


How many ways are there to do 'remove duplicate records in informatica'?

131


What is the reusable transformation?

147


What is a shortcut and copy in Informatica and how two are different with each other?

180






What all join we can perform in LOOKUP transformation?

142


Can we get 1st record through Informatica(without sequence number).

468


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

7483


Explain transaction control transformation in informatica

190


scenario where i can use only concurrent execution of workflow.

2028


What is the different lookup cache(s)?

169


What are the modules in Power Center

809


What is a stored procedure transformation?

152


What is aggregate cache in aggregator transformation?

168


Explain the shared cache and re-cache?

162