-
ETL Design Complex Logic
What is the most complex logic you have used in your ETL design?
-
What is constraint based error? how ll u clarify it?
dl_mstr
- Feb 10th, 2008
when data from a single source needs to be loaded into multiple targets And multiple target has primary foreign key relation constraint based loading is used For example : In the first ...
Phani
- Feb 16th, 2007
Hi,when data from a single source needs to be loaded into multiple targets, in that situation we use constraint based load ordering.Note: The target tables must have primary - foreign key relationships.regards,Phani...
-
In my source table 1000 rec's are there. I want to load 501 rec to 1000 rec into my Target table ?
dl_mstr
- Feb 10th, 2008
SELECT *FROM (select * from source_table ORDER BY rownum DESC) SourceWHERE rownum <= 501
sreedhark26
- Mar 12th, 2007
u can load 500 records, then we can use Transaction control transformation, give the condition for 500 records out of 1000.
-
1)What are the various test procedures used to check whether the data is loaded in the back end, performance of the mapping, and quality of the data loaded in INFORMATICA.2) What are the common problems developers face while ETL development
dl_mstr
- Feb 10th, 2008
To check data loaded in the backend can be done by collecting the session results from the reposistory tablesquality of dataloaded can be done by writing sql qureries on the target table.To Check perf...
tomtwj
- Mar 14th, 2007
Performance, Data quality, consistensy and exception handling, large various source types.
-
What is session recovery?
dl_mstr
- Feb 10th, 2008
If the recover option is not set and 10,000 records are committed then delete the record from the target table using audit fields like update_date.
vizaik
- Mar 25th, 2007
when ever session fails, then we have to follow these steps:if no commit is performed by the informatica server, then run session again.if at least one commit is performed by the session, recover...
-
What is Dataware house key?
dl_mstr
- Feb 10th, 2008
Surrogate key is know as datawarehouse key. Surrogate key is used as a unique key in warehouse where dupicate keys may exits due to type 2 changes.
shanthi1
- Mar 18th, 2007
There is a Dataware house key........plz go thru kimball bookEvery data warehouse key should be a surrogate key because the data warehouse DBA must have the flexibility to respond to changing descriptions and abnormal conditions in the raw data.
-
Write a query to retrieve the latest records from the table sorted by version(scd).
-
Informatica sessions
What is the difference between a session and a task?
dl_mstr
- Feb 8th, 2008
Seesions : Set of instructions to run a mappingTask: session is type of task. other than that informatica several type of task like Assignment,Command,Control,Decision,Email,Event-Raise,Event-Wait,Timer,session
-
Data profiling
1.)I am creating custom profile on the relational source because it is failing to create report due database fatal error (some table name pm_dp_m doesn't exists in the repository) but when i check the repository there r 247 tables created?pls help me 2. Pls anybody tell me how deploy the mappings workflows,sessions created at the development site to production site in real time? thanks in advance
-
Assignment task in informatica
What is Assignment task in informatica? In what situation this task will be executed? Where this task exits?
mdahiya81
- Feb 6th, 2008
The Assignment task allows you to assign a value to a user-defined workflow variable. To use an Assignment task in the workflow, first create and add the Assignment task to the workflow. Then config...
-
What happens if cache name is not entered in the lookup ?
-
What is Incremental Aggregation?
chandrarekha
- Feb 5th, 2008
When u enable the incremental aggregation ,it passes all the source rows to the mapping and uses the historical cache to perform the aggregate calculations
-
Which transformation useful for joining the multi table..........
I am retrieving the multi structures from source i want to define single target table structure for this which transformation i need to follow
-
What types of Errors occur when you run a session, can you describe them with real time example
kasisarath
- Jan 25th, 2008
There are several errors you will get. Couple of them are1. if informatica failed to connect data base2. If source file not eixsts in location3. If paramerters not initilized with parameter file4. incompataible piped data types etc.
-
How many types of facts and what are they?
senthilkar
- Jan 22nd, 2008
1. Regular Fact - With numeric values2.Factless Fact - Without numeric values
shiva
- Oct 30th, 2006
haithere r three types of factsAdditive Fact-Fact which is used across all dimensionssemi Additive Fact- Fact which is used some dimesion and not with some Non Additive Fact- Fact which is not used any of the dimesion
-
Mappings and Production Server?
How to move the mappings to the production server?
sekhar7791
- Jan 18th, 2008
HiFrist export the mapping, it will create a xml file and connect to production repository there import that xml file.Sekhar7791
-
IQD file
What is IQD file?
Kalpana gopinath
- Jan 14th, 2008
In Cognos u will have impromptu (reporting tool) in this all the report will be stored as report.IMR which is one dimensional (single view ) report .but when we want to build cubes&n...
-
Informatica source and targets with same fields
We have one source and 3 targets with same fields i.e empno,ename in all 3 targets and source, then the 1st row in source should go to 1st target, 2nd row in source should go to 2nd target and the 3rd row in source should go to 3rd target, 4th row again to 1st target , 5th row to target2 6th row to target 3 like this we need to transfer data how is it possible?
sandeep.vaishy
- Jan 14th, 2008
First Load Data from source To One dummy table in target with SEQ Gen T/R.in SEQ Gen T/R Set min value 1 and max value 3 and check the reset option.It will load the data with new column Values 1,2,3,1...
sekhar.ganta
- Jan 3rd, 2008
here we should use router transformation with 3 groups. suppose 3 targets are target1: condition multiples of 3?????????? select * from emp where (empno,0) in (select empno,mod(rownum,3) fro...
-
How to append records in flat file using Informatica?For eg : In Datastage we can append the records in flat file(sequential file) using the options i) overwrite the existinf file.ii) Append the existing file.
dl_mstr
- Jan 2nd, 2008
Write a post_session command in the session.For example : COPY C:PreviousFinaloutput.csv+C:newflatfilerecords.csv C:PreviousFinaloutput.csv
promila
- Jul 17th, 2007
HI , We can use /n as a delimiter to append data at the bottom and also checking the option - append in the workflow monitor . but i am not clear can we append data at the top . One way is to create&n...
-
How to append the records in flat file(Informatica) ? Where as in Datastage we have the options i) overwrite the existing fileii) Append existing file
dl_mstr
- Jan 2nd, 2008
Write a post_session command in the session.For example : COPY C:PreviousFinaloutput.csv+C:newflatfilerecords.csv C:PreviousFinaloutput.csv
sm1506
- Apr 7th, 2006
this is not there in Informatica v 7. but heard that its included in the latest version 8.0 where u can append to a flat file. Its about to be shipping in the market.
Informatica Interview Questions
Ans