Interested to Buy Any Domain ? << Click Here >> for more details...
Where can i get informatica certification Exam dumps and
details? please forward it to emailid: krisboppana@yahoo.com
- 320 Answers
- 284523 Views
- Accenture, College School Exams Tests, CTS, Flextronics, HCL, Infosys, NexGen, Patni, SO, Wipro, I also Faced
- E-Mail Answers
Answer Posted / pruthviraj109
Plz forward it to my mail id plz...
itspruthviraj@gmail.com
---Thanks in advance
Pruthvi :-)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
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.
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
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.
Which transformation we use to convert 'NA' to 'Not Available'
SCD2 will work on only dimension tables as well as fact Table?
What is the difference between project backlog and product backlog?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
Explain me ETL project architecture in Detail?
What is partitioning? Explain different types of partitioning?
when will use SQL override in a lookup transformation?
Difference between flat files and relational sources?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
Define Dynamic push down optmization?
Explain do we need an etl tool? When do we go for the tools in the market?
