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

explain about informatica server architecture?

IBM,

1 5906

what is the size of your data warehousing?

IBM,

1209

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

IBM,

1280

what is the dashbords?

IBM,

1 2867

what is the drillup & drill down?and use of the drill up and drill down?

IBM,

1 3306

how the informatica server sorts the strings values in rank transformations?

TCS,

3 13577

what are the output files that the informatica server creats during running a session?

CTS,

2 7046

why we use stored procedure transformation?

IBM,

4 6020

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 2726

What is the need of building a data warehouse?

2 3019

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

IBM,

1 2781

I need an oracle query for convert Char to Integer?. Can any one help me how to do this?

3 4244

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 2563

Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....

1 2142

what is data driven in informatica

IBM,

5 6489


Post New Informatica Questions






Un-Answered Questions { Informatica }

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1490


Explain how many types of dimensions are available in informatica?

204


Differentiate between router and filter transformation?

159


What are Dimensional table?

210


What are different types of transformations available in informatica?

188






Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

177


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

185


How to extract sap data using informatica?

207


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

170


Differentiate between reusable transformation and mapplet.

147


Explain sql transformation in script mode examples in informatica

216


Whats the difference between informatica powercenter server, repositoryserver and repository?

213


Please let me know how to make encryption and decryption with example?

781


Explain about Informatica server process that how it works relates to mapping variables?

209


What is meant by incremental aggregation?

167