1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
Informatica Interview Questions
Questions Answers Views Company eMail

we have to use order by,where,having we to implement sql query

Satyam,

1 4451

in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

Cognizant,

1 2375

in performance wise union is past,union all is past

2 4225

in oracle write query yourname+1 from dual

 5 6001

split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar

Cap Gemini, TCS, Wipro,

1 14686

what is the difference between stop and abort

 2 4616

tell me about your project functionality

 1856

tell me 7.x and 8.x diferrencess(but not transformations)

 1 3137

tell me the rules and responsblites in our project(my project is development)

 1487

tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use

 1 2944

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

 1484

with out using update strategy transnsformation how to update the data in mapping level

 1 4040

how to get the only updated records in the target

 2 4862

how to get flatfile containg 10 records half records one target another half another target

 2 4569

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

Accenture,

6 10251

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is status code in informatica?

570

write a query to retrieve the latest records from the table sorted by version(scd)

625

How to configure mapping in informatica?

666

Sequence generator, when you move from develoment to production how will you reset

1393

Write the prerequisite tasks to achieve the session partition?

631




Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

543

can anyone suggest best free Talend data integration training online

1246

If informatica has its scheduler why using third party scheduler?

759

what is the hint? how to use it to reduce the query processing in program?

6269

Explian the Process of deployment groups in informatica

646

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1467

What is the way to execute pl/sql script using informatica mapping?

950

Explain Dataware house architecture .how data flow from intial to end?

2109

How you prepared reports for OLAP?

1140

What is the difference between STOP and ABORT options in Workflow Monitor?

687

For More Un-Answered { Informatica } Questions Click Here