-
What r the diffrence between joiner transformation and source qualifier transformation?
U can join hetrogenious data sources in joiner transformation which we can not achieve in source qualifier transformation. U need matching keys to join two relational sources in source qualifier transformation.Where as u doesn’t need matching keys to join two sources. Two relational sources should come from same datasource in sourcequalifier.U can join relatinal sources which r coming from diffrent...
divakar
- Nov 5th, 2007
source qualifier is used for reading the data from the database where as joiner transformation is used for joining two data tables.source qualifier can also be used to join two tables but the conditio...
pkonakalla
- May 23rd, 2007
hi, as per my knowledge, you need matching keys to join two relational sources both in Source qualifier as well as in Joiner transformation. But the difference is that in Source qualifier, both the keys must have primary key - foreign key relation, Whereas in Joiner transformation its not needed.
-
Differences between connected and unconnected lookup?
Connected lookupUnconnected lookup Receives input values diectly from the pipe line.Receives input values from the result of a lkp expression in a another transformation.U can use a dynamic or static cache U can use a static cache.Cache includes all lookup columns used in the mapingCache includes all lookup out put ports in the lookup condition and the lookup/return port. Support user defined...
ASHOK1324
- Apr 21st, 2009
1]. Connected lookup receives input values directly from mapping pipeline whereas UnConnected lookup receives values from: LKP expression from another transformation.2]. Connected lookup can use ...
Shivat
- Sep 13th, 2006
Hi Differences Between Connected and Unconnected LookupsConnected LookupUnconnected LookupReceives input values directly from the pipeline.Receives input values from the result of a :LKP expressi...
-
How can u recognise whether or not the newly added rows in the source r gets insert in the target ?
In the Type2 maping we have three options to recognise the newly added rows Version number Flagvalue Effective date Range
ASHOK1324
- Apr 21st, 2009
In the SCD Type2, we have three options to recognise the newly added rows: 1. Version number 2. Flag value 3. Effective Date Range
Prasath
- Oct 4th, 2007
Just use debugger to know how the data from source moves to target, it will show how many new rows get inserted else updated.
-
What r the different options used to configure the sequential batches?
Two options Run the session only if previous session completes sucessfully. Always runs the session.
Vani_AT
- Apr 1st, 2008
I would like to make a small correction for the above answer.Even if a session fails with the above property set,all the following sessions of the workflow still run and succeed depending on the valid...
sn3508
- Aug 24th, 2007
You have to specify those options in the workflow designer. You can double click the pipeline which connects two sessions and there you can define prevtaskstatus=succeeded. Then only the next se...
-
Can u start a batches with in a batch?
U can not. If u want to start batch that resides in a batch,create a new independent batch and copy the necessary sessions into the new batch.
-
How to read the data from XML and flat files in informatica?
MAHESH MANAM
- Aug 16th, 2012
From flat file you use the following wys: --> In source analyzer you can create file by manually -->you can import file -->you can use any of the flat file and give session properties in that correc...
dileep671
- Aug 3rd, 2012
Go to Source analyzer , then import XML Source, a wizard opens up.. select the Schema Definition (XSD) of th XML file
When you run the session, give the XML file name and XML file directory path. -
-
At the max how many tranformations can be us in a mapping?
Ray
- Mar 22nd, 2006
Always remember when designing a mapping: less for moredesign with the least number of transformations that can do the most jobs.
premlahari
- Dec 13th, 2005
There is no such limitation to use this number of transformations. But in performance point of view using too many transformations will reduce the session performance. My idea is "if needed ...
-
Suppose session is configured with commit interval of 10,000 rows and source has 50,000 rows. Explain the commit points for Source based commit and Target based commit. Assume appropriate value wherever required.
prade
- Jun 26th, 2008
In case of a source based commit, the integration services generates a commit row from the active sources and writes the rows into the target. The number of rows processed from the "active source...
vivek1708
- May 11th, 2008
I dont think above written statement is correctMyunderstanding is that for source based commit: a session as soon as it reads 10k rows from the source it performs a commitand similarly for tbc: as soon as it write 10k rows to targt it does a commit
-
Could anyone please tell me what are the steps required for type2 dimension/version data mapping. how can we implement it
babushiv
- May 24th, 2010
The Type 2 Dimension Data mapping inserts both new and changed dimensions into the target. Changes are tracked in the target table by versioning the primary key and creating a version number for each ...
Rob
- Apr 25th, 2006
1. Determine if the incoming row is 1) a new record 2) an updated record or 3) a record that already exists in the table using two lookup transformations. Split the mapping into 3 seperate flows using...
-
With out using Updatestretagy and sessons options, how we can do the update our target table?
prasadns26
- Jul 18th, 2006
hi,if ur database is teradata we can do it with a tpump or mload external loader.update override in target properties is used basically for updating the target table based on a non key column.e.g upda...
Raajavarman
- Mar 11th, 2006
By default all the rows in the session is set as insert flag ,you can change it in the session general properties -- Treate source rows as :update...
-
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...
-
Can i use a session Bulk loading option that time can i make a recovery to the session?
ram_infa
- Sep 13th, 2011
Nope! when you use bulk loading you can't recover the rows caz it won't write database logs.
suresh.ravirala
- Mar 17th, 2006
no,why because in bulk load u wont create redo log file,when u normal load we create redo log file,but in bulk load session performance increases
-
What is worklet and what use of worklet and in which situation we can use it
sn3508
- May 12th, 2008
Besides the reusability of a worklet as mentioned above, we can also use a worklet to group related sessions together in a very big workflow. Suppose, we have to extract a file and then load a fact table, in the workflow we can use one worklet to load/update dimensions.
Shanmugam
- Jul 6th, 2006
Worklet is reusable workflows. It might contain more than on task in it. We can use these worklets in other workflows.
-
What is the difference between Power Centre and Power Mart?What is the procedure for creating Independent Data Marts from Informatica 7.1?
chandrarekha
- May 7th, 2007
Power centre includes data partitioning and multi server registrationswhere as power mart does not include those
ramana
- Apr 30th, 2006
pc =========1 &n...
-
How will you populate the time dimension table ?
Rohith Yogendra
- Apr 20th, 2007
CREATE OR REPLACE PROCEDURE TIMEDIMBUILD (p_start_date IN DATE, p_end_date IN DATE)AS v_full_date DATE; v_day_of_month NUMBER; v_day_of_year NUMBER; v_da...
Rohith Yogendra
- Apr 20th, 2007
Hi this would be the normal SP Code that i use to populate a time dimension,well again it depends on the business requirements to know what level the Grain is required for a time dimensionCREATE OR RE...
-
How to reduce load times
Suppose one flat file taking loading time of 3 hrs.How u can reduce that loading time to 1 hr.( No FTP, Not UNIX system to make parallel processing,No splitting file,and all servers and files and targets existing in same system)
rags.sarath
- May 20th, 2008
If ur source is flat file,the pcs reads 1024 bytes perone line.If the line containg the bytes less than this number to improve session performance u can tune the 'Line sequntial buffer lenth" in session properties.
UmaBojja
- Aug 14th, 2007
One?can use Nway partition at the source side.We have to partition the session and give the source file name only for the first partition.Server will automatically takecare.Please check if you have that feature. It?a new feature started from 7.1.2ThanksUma Bojja
-
-
-
What is meant by EDW?
yugandhar.bo
- May 15th, 2006
EDW is Enterprise Datawarehouse which means that its a centralised DW for the whole organization.this apporach is the apporach on Imon which relies on the point of having a single warehouse/centr...
Informatica Interview Questions
Ans