-
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
-
Write a query to retrieve the latest records from the table sorted by version(scd).
-
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.
-
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...
-
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.
-
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.
-
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...
-
ETL Design Complex Logic
What is the most complex logic you have used in your ETL design?
-
Why you cannot use dynamic cache in flat file ?
manojkumarkurnool
- Feb 13th, 2008
flatfile is only a permanent store age device means it flow only read processbut dynamic cache is used for read and wirte process so in a flat file u cannot use a dynamic cache in flatfiles
-
How to link informatica with database (oracle or sql server)
Hello,could anyone please guide me ,how to link with database(oracle database or sql server),iam new to informatica, please tell me the path to link these 2 because iam practising in my homewith my computer.please anyone help me.rkumar_123thanks in advance
manojkumarkurnool
- Feb 13th, 2008
hi to all infomatica people in order to link infomatica with database an infomatica developer or etlconsutant has to use ODBC Connections (open database connectivity driver)which are their in infomati...
-
How do you use Normalizer to convert columns into rows ?
Deepak Rajkumar
- Feb 18th, 2008
Using Normalizer, in the normalizer properties we can add coloumns and for a coloumn we can specify the occurance levels, which converts rows into coloumns.
-
What happens when the session stops half way while loading? How to join a flat file without matching keys in RDBMS?
Sreeya
- Feb 21st, 2008
For the 1st part, we can adopt the recovery options as given in the session property, using the recovery strategy.But using this in real time scenario has proved to take a toll on the performance.Anot...
Deepak Rajkumar
- Feb 18th, 2008
Not sure about session stops without loading. We can join flat files without matching coloumns by:1: use a Seq. Gen. and generate Pks and join using Joiner.
-
Informatica PowerCenter repository server configuration error - "the server could not contact" message
Hi, This is Ram working as a system administrator I had installed the Informatica PowerCenter 7.1.1 and when i was configuring the repository server it is giving "the server could not contact" message, I never faced this problem before pls anybody had any solution pls send to me as early as possible i tried all the possible ways to solve this problem but i could not get it so pls help me in this regard.
pal.amol
- Feb 25th, 2008
Hi Ram,You could first go to repository manager give relational connection and then you could configure server add new and give details.Give port name as defined in the configue repository serve...
akmohanty
- Feb 8th, 2007
At the time of configuring the repository server just give the port number is 5001 and put a passwordThen start the service first then open the repository server administrator console.Just connect it ...
-
Run sessions
How do you run sessions one after another?
pal.amol
- Feb 25th, 2008
There are two methods for running the session one is to run concurrently and second one is to run sequentially which you want to do. There are three things need to be configured at properties lev...
-
Sorter in Active Transformation
Why is sorter an active transformation? What happens when you uncheck the DISTINCT option in sorter?
MMSheriff
- Feb 27th, 2008
Sorter is an active transformation since it eliminate the duplicate records when the distinct option box is checked.The uncheck distinct option will lead to show duplicate records
-
Why cant we use more than two groups connecting the target in router transformation?
Amritendra kumar
- Feb 29th, 2008
My dear we can use more than two group in router transformation. it is the main purpose of router to define many condition. there is one default output also so if you are giving 4 condition there than output will be 5. and for this we need 5 target.hope it will help.thanks
sekhar.ganta
- Jan 3rd, 2008
we can use more than two groups connection the target . If you take emp table, for this we we have to take 3 targets,for the purpose of If sal
-
Informatica Mapping level Questions
in mapping level we have update strategy in that we have DD-update and at session level we have DD_insert when we run mapping what will happen is it inserted or updated?
Amritendra kumar
- Feb 29th, 2008
As per my openion it will insert only because it give preference to session
chandrarekha
- Feb 5th, 2008
It performs insert operation,because session overwrites the mapping level properties
-
Apply Business Rules
Where do we apply business rules from souce to staging or staging to warehouse?
Amritendra kumar
- Feb 29th, 2008
Actually we don't apply business rule . we only treat the data according to the business rule and in this work we get help by business analyst. in staging area we generally do cleansing ...
-
Connect two sources
How to connect two sources with connecting field without using joiner and lookup?
-
How to return more than two values from an unconnected lookup?
Amritendra kumar
- Feb 29th, 2008
Unconnected lookup only return 1 port but if you want to return 2 port then u have to play mind game mean u hav to use concatenate operator in expression editor.
Informatica Interview Questions
Ans