-
What r the basic needs to join two sources in a source qualifier?
Two sources should have primary and Foreign key relation ships. Two sources should have matching data types.
-
What r two types of processes that informatica runs the session?
Load manager Process: Starts the session, creates the DTM process, and sends post-session email when the session completes. The DTM process. Creates threads to initialize the session, read, write, and transform data, and handle pre- and post-session operations.
ASHOK1324
- Apr 21st, 2009
Load manager Process: Starts the session, creates the DTM process, and sends post-session email when the session completes. The DTM process: Creates threads to initialize the session, read, write, and transform data, and handle pre- and post-session operations.
rasmi
- Sep 17th, 2007
When the workflow start to run,Then the informatica server process startsTwo process:load manager process and DTM Process;The load manager process has the following tasks1. lock the workflow and read ...
-
Can u generate reports in Informatcia?
Yes. By using Metadata reporter we can generate reports in informatica.
srinivas.j.abinitio
- Jul 1st, 2011
Yes.?with using informatica Reporting too is informatica Analyzer.Thanks&Regards,Srinivas.
-
What is DTM process?
After the loadmanger performs validations for session,it creates the DTM process.DTM is to create and manage the threads that carry out the session tasks.I creates the master thread.Master thread creates and manges all the other threads.
a.himakar
- Sep 7th, 2010
It is the main processing unit in Informatica for executing the session with corresponding mappings. It has 3 sub services as 1) Reader Thread : It uses source table and source connections to ex...
ASHOK1324
- Apr 21st, 2009
The DTM process creates threads to initialize the session, read, write, and transform data, and handle pre- and post-session operations.
-
Can u start a session inside a batch idividually?
We can start our required session only in case of sequential batch.in case of concurrent batch we cant do like this.
Vani_AT
- Apr 1st, 2008
Yes, we can do this in any case. Sequential or concurrent doesn't matter.Ther is no absolute concurrent workflow. Every workflow starts with a "start" task and hence the workflow is a hybrid.
-
How can u stop a batch?
By using server manager or pmcmd.
VEMBURAJ.P
- May 28th, 2007
By using menu command or pmcmd.
-
What r the session parameters?
Session parameters r like maping parameters,represent values U might want to change between sessions such as database connections or source files. Server manager also allows U to create userdefined session parameters.Following r user defined session parameters. Database connections Source file names: use this parameter when u want to change the name or location of session source file between session...
Vani_AT
- Apr 1st, 2008
A small correction, it starts with single dollar symbol . double dollar symbol is used for mapping parameters.
Vani_AT
- Apr 1st, 2008
In addition to this we provide the lookup file name.The values for these variables are provided in the parameter file and the parameters start with a $$ (double dollar symbol). There is a predefined f...
-
What is tracing level and what are the types of tracing level?
Tracing level represents the amount of information that informatcia server writes in a log file. Types of tracing level Normal Verbose Verbose init Verbose data
Sumithav29
- Jun 12th, 2009
When you configure a transformation, you can set the amount of detail the Integration Service writes in the session log.The session log tracing levels are: 1. Normal: Integration Service logs initial...
Minnu
- Apr 16th, 2007
Its 1) Terse 2) Normal 3) Verbose Init 4) Verbose data
-
How do you import 500file from tally software in informatica. ?
Hemachandra
- Sep 26th, 2011
With my knowledge BY using LIST FILE we can do
jayapraveen
- Oct 8th, 2010
with my knowledge Consider the 500 file as a flat file and import it considering it as a flat file by fixed length or fixed tab, delimiters OR we can do in this way also by exporting the 500 file as xml file and import in source analyzer by using import from xml file
-
-
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.
-
How do you recover a session or folder if you accidentally dropped them?
satoru
- Jun 10th, 2010
You disconnect from repository without saving or if you're using versioning you can look in the check_out option from all users and restore them, though if you delete the folder you can restore it by versioning.
hanug
- May 8th, 2007
u can find ur backup and restore from the backup. If u dont have backup,u lost everything. u cant get it back.Thats why, we should always take the backup of the objects that we create.Hanu.
-
How do you recover a session or folder if you accidentally dropped them?
priyank_divya
- Jul 9th, 2012
If we drop any sessions accidentally, it wont be deleted permanently until we do a check in. So if we want to recover the session, we can do a undo checkout on the session.
N SRIRAM K
- Jun 1st, 2007
If you dropped your session or folder we can get it back if it has proper backup.we can also get it back when you have same folders in other environment, I mean to say, generally, we will have th...
-
What is the difference between fact and measure?
Sim
- Feb 2nd, 2012
Measures are calculations based on facts. A measure points to a fact (such as order amount) and specifies an aggregation function (such as average or sum).
vizaik
- Mar 26th, 2007
the real meaning of fact is what are all the necessary information for a business.Ex: in a business, customer,item,order,invoices tells information.calculation of amt to be paid by the customer is the...
-
What is inline view?
vizaik
- Mar 24th, 2007
Used in oracle to simplify queriesex: select rowid from (select ename from emp group by sal) where rowid<2
Hanu Ch Rao
- Feb 22nd, 2007
The inline view is a construct in Oracle SQL where you can place a query in the SQL FROM, clause, just as if the query was a table name.A common use for in-line views in Oracle SQL is to simplify complex queries by removing join operations and condensing several separate queries into a single query
-
If a record is updated multiple times before session is run, How do you track those changes in SCD Type 2?
narendraterainfo
- Oct 14th, 2012
If the ETL is not ussing Full Pushdown optimization or Target Pushdown optimization . We can track with insert Time_stamp
priyank_divya
- Jul 9th, 2012
We can track the changes in SCD type 2 in many ways:
--> A time column
--> Mentioning a version -
How can we delete duplicate rows from your source in mapping without using SELECT DISTINCT option in source qualifier?
hemachandra
- Dec 26th, 2007
Also you can use group by on all columns you are pulling either by sql override or aggrigator
-
How do you change change column to row in Informatica
sreedhark26
- Mar 12th, 2007
First u can ask what type of data change columns to rows in informatica?Next we can use expression and aggregator transformation.aggregator is using group by duplicate rows
Hanu Ch Rao
- Mar 2nd, 2007
Hi,We can achieve this by Normalizer trans.
-
How to do aggregation with out using AGGREGAROR Transformation ?
hemasundarnalco
- Mar 9th, 2007
Write a sql qurey to perform an aggregation in the source qualifier transformation
-
How do you store Historical data in a DWH ?
1.How do you store Historical data in a DWH?2.What is the primary purpose of using surrogate key? Will those be used in fact tables?If not then what is the purpose in using it?3. How do you update Information in Update strategy Transformation?4. How do you validate data after you have transferred it into target table from flat files?
vizaik
- Mar 15th, 2007
By using scd2, we can store historical data.Surrogate key is used for indexing purpose. i.e. as a primary key for a table. You can say that why can't we use primary key. But the ...
vizaik
- Mar 15th, 2007
By using scd2, we can store historical data.Surrogate key is used for indexing purpose. i.e. as a primary key for a table. You can say that why can't we use primary key. But the ...
Informatica Interview Questions
Ans