1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

Using Connected or unconnected lookup for performance wise which one is preferable?.

Deloitte,

1 1885

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

HCL,

1034

Can anyone tell me what are the roles and responsibilities of informatica support ( L1, L2, & L3 ) Team?

IBM, Saama Tech, Wipro,

1 1080

How to increase performance without changing anything in mapping.( In prod)

IBM, Saama Tech, Wipro,

775

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

IBM, Saama Tech, Wipro,

775

How to delete data which is not in source table?

IBM, Saama Tech, Wipro,

822

What are the different ways to deploy the code in informatica?

IBM, Saama Tech, Wipro,

1 1573

I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?

Accenture, Saama Tech, TCS,

2 2638

In a table 100 records are there after 50records job is aborted how can u insert all records in target table.

Cap Gemini,

1 2107

Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.

CTS,

900

On which transformations you created partitions in your project?

Cap Gemini,

748

Find 2 highest sal from each dept who have completed 5 year in org

Wipro,

1127

if collect stats but it show low confidence why?

IBM,

1171

can anyone suggest best free Talend data integration training online

 1245

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

 1017

Un-Answered Questions { Data Warehouse }

What is session task and command task?

633

Define query items?

585

How we can decided drilling options for an attribute?

522

Difference between output_index and output_indexes in reformat

742

what is the role of skipcheck in tm1?

5




Tell me about Propagate functions in informatica

512

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1190

What is the sequence generator transformation in informatica?

599

: and & modifiers.

853

What is data type of the surrogate key?

597

How to go to the older version for a mapping?

586

What is percent-to-total shortcut metric in microstrategy?

536

what is data governance? : Sas-di

609

what is hints in cognos and where we use it.

1980

How can we run the graph?

568

For More Un-Answered { Data Warehouse } Questions Click Here