-
How to load time dimension?
manisha.sinha
- Dec 29th, 2006
create a procedure to load data into Time Dimension. The procedure needs to run only once to popullate all the data. For eg, the code below fills up till 2015. You can modify the code to suit the feil...
kumar
- Sep 28th, 2006
For loading data in to other dimensions we have respective tables in the oltp systems..But for time dimension we have only one base in the OLTP database. Based on that we have to load time dimension. ...
-
For homogeneous sources we use Source Qualifier to join the sources? Why not the joiner transformation.
vinodh259
- May 11th, 2007
who said that we cant use joiner for homogenous sources. but the thing is performace becomes bad if we use joiner transformation after source qualifier.? it is for the fact that for any sources (homo&...
Phani
- Feb 16th, 2007
This is because performing join at database level is must faster than performing join at session level. So, if source tables r originating from the same database( say relational) prefer join in the source qualifier transformation than for opting joiner transformation.regards,Phani...
-
In which particular situation we use unconnected lookup transformation?
sridhar39
- Dec 28th, 2007
hi, both unconnected and connected will provide single output. if it is the case that we can use either unconnected or connected i prefer unconnected why because uncon...
Tarun Vig
- Oct 12th, 2007
Use of connected and unconnected Lookup ic completely based on the logic which we need.However i just wanted to clear that we can get multiple rows data from an Unconnected lookup also.Just concatinat...
-
You transfer 100000 rows to target but some records get discard. How wil you trace them? and where its get loaded?
sreedhark26
- Jan 6th, 2007
Session failed after loading 10000 records, opb_server_recovry file loads the records, it maintains the record id, correct the error again run the session , session will take 10001 record on words
ravi guturi
- Jan 5th, 2007
Yes, we will find out discarded rows by using row indicator and coloum indicator..Row inidicator:DONTD-validO-overflowN-nullT-truncateColumn Indicator:01230-insert1-update2-delete
-
What happens if cache name is not entered in the lookup ?
-
How to get 25 of 100 fields table is there any transformation available in informatica i know router/filter or any other?
raju
- Nov 19th, 2006
I faced this qus in accenture interview
-
What is DTM process?
itisanimesh
- Nov 6th, 2009
The Load Manager creates one DTM process for each session in the workflow. It performs the following tasks: Reads session information from the repository. Expands the server, session, and mapping...
dl_mstr
- Feb 11th, 2008
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.
-
-
What is Data Transformation Manager?
After the load manager performs validations for the session, it creates the DTM process. The DTM process is the second process associated with the session run. The primary purpose of the DTM process is to create and manage threads that carry out the session tasks.· The DTM allocates process memory for the session and divide it into buffers. This is also known as buffer memory. It creates the main thread,...
Read Best Answer
Editorial / Best Answer
Goush- Member Since May-2007 | May 15th, 2007
When the workflow reaches a session, the Integration Service process starts
the DTM process. The DTM is the process associated with the session and it
performs the following tasks:
1. Retrieves and validates session information from the repository.
2. Performs pushdown optimization when the session is configured for
pushdown optimization.
3. Adds partitions to the session when the session is configured for dynamic
partitioning.
4. Forms partition groups when the session is configured to run on a grid.
5. Expands the service process variables, session, and mapping variables and
parameters.
6. Creates the session log.
7. Validates source and target code pages.
8. Verifies connection object permissions.
9. Runs pre-session shell commands, stored procedures and SQL.
10. Sends a request to start worker DTM processes on other nodes when the
session is configured to run on a grid.
11. Creates and runs mapping, reader, writer, and transformation threads to
extract, transform, and load data.
12. Runs post-session stored procedures, SQL, and shell commands
13. Sends post-session email.
jayapraveen
- Oct 4th, 2010
load manager creates the DTM(data transformation manager)in the work flow manager by the informatica server ,here DTM creates two threads 1.reader thread2.writer threadDTM reads the data from &nb...
chandrarekha
- Sep 6th, 2007
Load manager and DTM are the components of Informatica server. Load manager manages the load on the server by maintaining a queue of sessions and release the session based on first come and firs...
-
How can you create or import flat file definition in to the warehouse designer?
U can not create or import flat file defintion in to warehouse designer directly.Instead U must analyze the file in source analyzer,then drag it into the warehouse designer.When U drag the flat file source defintion into warehouse desginer workspace,the warehouse designer creates a relational target defintion not a file defintion.If u want to load to a file,configure the session to write to a flat...
ASHOK1324
- Apr 18th, 2009
1] Add the metadata of source file into Informatica designer using source analyzer and save source file definition in the repository.2] When we drag the source file definition into warehouse desig...
Latha.
- Sep 3rd, 2007
While creating flatfiles manually, we drag and drop the structure from SQ if the structure we need is the same as of source, for this we need to check-in the source and then drag and drop it into the Flatfile, if not all the columns in the source will be changed as primary keys.
-
What r the unsupported repository objects for a mapplet?
COBOL source definition Joiner transformations Normalizer transformations Non reusable sequence generator transformations. Pre or post session stored procedures Target defintions Power mart 3.5 style Look Up functions XML source definitions IBM MQ source defintions
kvrp461
- Aug 18th, 2010
1)Stored procedure preload or postload is not possible.2)Dont allow the not reusable sequence generator.3)xml source qualifier4)Normalizer5)Nested mapplets
job_infa
- Jan 28th, 2009
−Normalizer transformations−Cobol sources−XML Source Qualifier transformations−XML sources−Target definitions−Pre- and post- session stored procedures−Other mapplets-PowerMart 3.5-style LOOKUP functions-non reusable sequence generator
-
What r the join types in joiner transformation?
Normal (Default) Master outer Detail outer Full outer
-
What r the mapings that we use for slowly changing dimension table?
Type1: Rows containing changes to existing dimensions are updated in the target by overwriting the existing dimension. In the Type 1 Dimension mapping, all rows contain current dimension data. Use the Type 1 Dimension mapping to update a slowly changing dimension table when you do not need to keep any previous versions of dimensions in the table. Type 2: The Type 2 Dimension Data mapping inserts both...
ASHOK1324
- Apr 21st, 2009
The Dimensions are classified 3 types.
1.SCD TYPE1 (Slowly Changing Dimension) : contains current data.
2.SCD TYPE2 (Slowly Changing Dimension) : contains current data + complete
historical data.
3.SCD TYPE3 (Slowly Changing Dimension) : contains current data + recent
historical data.
Rp
- Oct 4th, 2007
SCD: Source to SQ - 1 mapping, SQ to LKP - 2 mapping, SQ_LKP to EXP - 3 Mapping, EXP to FTR - 4 Mapping, FTR to UPD - 5 Mapping, UPD to TGT - 6 Mapping, SQGen to TGT - 7 Mapping. I thin...
-
What are the steps involved in to get source from OLTP system to staging area
ramsetty
- Jun 17th, 2009
Data profiling is a technique used to analyze the content, quality, and structure of source data. Use PowerCenter Data Profiling to detect patterns and exceptions of source data during mapping develop...
vizaik
- Mar 24th, 2007
go to source analyzerimport databasesgo to warehouse designerimport databases (target definitions) else create using generate sqlgo to mapping designerdrag and drop sources and targets definitionslink ports properlysave to repositorythan q
-
Can we update target table without using update strategy transformation? why?
Amit Gaikwad
- Jul 26th, 2012
Step 1: Go to session , and in treat source rows as :UPDATE
step2: in target table option select INSERT and UPDATE ELSE INSERT :)
Step 3:Refresh and Run the session .nagadurgaraju
- Sep 1st, 2010
By using source qualifier transformation to update tha target table,through SQL overriding...
-
How do you handle two sessions in Informatica
Can any one tell me the option between the two session . if previous session execute successfully than run the next session...
vizaik
- Mar 24th, 2007
you can drag and drop more than one session in a workflow.there will be linking different and issequential linkingconcurrent linkingin sequential linking, you can run which ever session you require or...
chsrikanth15
- Mar 2nd, 2007
Where exactly do we need to use?this link condition (id $ PrevTaskStatus = SUCCESSFULL)
-
Source Qualifier in Informatica
What is the Technical reason for having Source Qualifier in Informatica? Can a mapping be implemented without it? (Please don't mention the functionality of SQ) but the main reason why a mapping can't do without it...
manojrana
- Apr 7th, 2010
The most important significance of source qualifier is that it converts the datatypes (coming from a source) into informatica compatible datatypes.Rest all properties like distinct, overide, filtering records can be achieved by other transformations of informatica as well.
chandra Bose
- Sep 4th, 2007
In informatica source qualifier acts as a staging area, and it?will create?its own?data types which are related to source data types
-
How do you take only duplicate rows in target table in Informatica
priyank_divya
- Jul 9th, 2012
Hi, One way of getting only the duplicate columns loaded in the target table is to modify the SQ query: When primary keys are defined: select * from where exists (select PK1,PK2,... from group b...
koustav
- Jul 31st, 2007
I think you can write the sql query (delete from....) in session post-sql command and it will work good.
-
What is use of event waiter?
sithu
- Mar 24th, 2007
Event wait: will hold the workflow until it is get other instruction or delay mentioned by the userCheers,Sithusithusithu@hotmail.com
sanghala
- Mar 9th, 2007
Event Wait task is a file watcher.when ever a trigger file is touched/created, this task will kick off the rest of the sessions to execute which are there in the batch.I used only User defined Event wait task.
-
What is confirmed dimension?
bharath
- Mar 2nd, 2007
It is also called as fixed dimension.It is a dimension which doesnot effect with respect to time.for example if the name of the city is changed from bombay to mumbai,the name will not change from time...
Informatica Interview Questions
Read Best Answer
Ans