itjmn

 Profile Answers by itjmn Questions by itjmn

• Apr 12th, 2010

Chaning / altering the default querly generated by the following transformations is known a SQL Override.1. Source Qualifier Transformations2. Lookup3. Target

Vamsi Krishna.K

• Oct 1st, 2006

Hello,By default informatica server will generate sql query for every action, if that query is not able to perform the exact task, we can modify that query or we can genrate new once with new conditions and with new constraints.1. source qualifier2. lookup3. target

Answer Question  Select Best Answer

pradeeshkumar

 Profile Answers by pradeeshkumar Questions by pradeeshkumar

• Aug 19th, 2010

The frequency of loading data is based on the needs. It may be once in a week or at every nights.

opbang

 Profile Answers by opbang Questions by opbang

• Oct 4th, 2006

Loading frequency depends on the requirement of Business Users,  It could be daily during mid night... or weekly...  Depending on the frequency...  ETL process should take care... how t...

Answer Question  Select Best Answer

n k rajkumar

• Oct 18th, 2006

There are two types of target load typesthey are1. bulk2. normal

phanimv

 Profile Answers by phanimv Questions by phanimv

• Oct 18th, 2006

we define target load plans in 2 ways1. in mapping2. in session

Answer Question  Select Best Answer

phanimv

 Profile Answers by phanimv Questions by phanimv

• Oct 18th, 2006

Using flat files sql override willnot work. the extension of the flat files are .txt,.doc,.dat and the output or target flatfile extension is .out

Rajesh

• Oct 10th, 2006

In Flat file SQL Override will not work. We have different properties to set for a flat file. If you are talking about the flat file as a source it can be of any extension like .dat,.doc etc. Yes if i...

Answer Question  Select Best Answer

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Oct 14th, 2010

SURROGATE KEY IS NOTHING BUT WHAT A PRIMARY KEY IS USED IN AN TRANSACTION DATABASE ,GENERALLY THIS COME IN PICTURE WHEN THE DATA IS UPDATING REGULARLY IN THE TABLE THIS MAKES THE TABLE INCONSISTENT SO...

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Oct 25th, 2006

Surrogate key or warehouse key acts like a composite primary key.  If the target doesn't have a unique key, the surrogate key helps to address a particular row.  It is like a primary key in the target.

Answer Question  Select Best Answer

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Jan 9th, 2007

event based scheduling is using for row indicator file. when u dont no where is the source data that time we use shellcommand,script, batch file to send to the local directory of the informaticaserver is waiting for row indiactor file befor running the session.

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Oct 25th, 2006

In time based scheduling, the jobs run at the specified time.  In some situations, we've to run a job based on some events like if a file arrives then only the job has to run whatever the time it is.  In such cases, event based scheduling is used.  

Answer Question  Select Best Answer

pushpam

 Profile Answers by pushpam Questions by pushpam

• Nov 3rd, 2006

Toad is a application development tool built around an advanced SQL and PL/SQL editor. Using Toad, you can build and test PL/SQL packages, procedures, triggers, and functions. You can create and edit ...

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Oct 26th, 2006

TOAD is a user friendly interface for relational databases like Oracle, Sql Server, DB2.  While unit testing the development or query on tables, one can use TOAD with basic  knowledge on database commands.

Answer Question  Select Best Answer

sathishkumar_sundaram

 Profile Answers by sathishkumar_sundaram Questions by sathishkumar_sundaram

• Nov 6th, 2006

Hi,E-R model is Entity Relation model used in Two dimesional Databases.For Example, SQL Server, or Oracle. A table is based on two dimensions.Rows and Columns.Generally, OLTP systems are based on...

Arjun

• Nov 1st, 2006

This is Entity - Relation model which is used for normalising the data

Answer Question  Select Best Answer

tshah

 Profile Answers by tshah Questions by tshah

• Jun 6th, 2008

Unless the job is scheduled, you cannot manually run a workflow without using a GUI.

balaetl

 Profile Answers by balaetl Questions by balaetl

• Aug 3rd, 2007

Pmcmd is not GUI. It is a command you can use within unix script to run the workflow.

Answer Question  Select Best Answer

I have a requirement to convert date format.my requirement is as followsi hav date column in my source.my source data in date columnv_date10-11-200619-aug-199925-dec-05null11-5-05like thismy requirement is,it has to send me the output as dd-mon-yyyy like 26-nov-2006.if in v_date column required format is not there it has to convert it the correct format,if the record is in the correct format it has...

superhero

 Profile Answers by superhero Questions by superhero

• Dec 8th, 2008

IIF(ISNULL(V-date),TO_DATE(SYSDATE, 'dd-mon-yy')IIF(IS_DATE(v-date),TO_DATE(v_date,'dd-mon-yy'),'Invalid Date')

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Sep 13th, 2007

Simple use expression transformation and make all the inputs into the date format given. Add a condition like IIF(ISNULL(V-date),SYSDATE(),IIF(IS_DATE(v-date),TO_DATE(v_date,'dd-mon-yy'),'Invalid Date')This is my idea. It helps you hopefully....thx

Answer Question  Select Best Answer

shambhu

• Feb 25th, 2016

1. SQ is used to represent the data from sources (relational, flat file) which Integration service can read
2. Normalizer is used as a source qualifier when we have Cobol source (Denormalized), which SQ can not read
3. Normalizer can be used for transposing columns into rows

RSUDHAKARREDDI

 Profile Answers by RSUDHAKARREDDI Questions by RSUDHAKARREDDI

• Jun 20th, 2011

Source qualifier transformation extract data from only files and rdbms.but normaliser transformation used to extract data from COBOL files.

Answer Question  Select Best Answer

Sumithav29

 Profile Answers by Sumithav29 Questions by Sumithav29

• Jun 26th, 2014

In the File propertes, we have an option Number of intial rows to skip

Rajesh

• Jan 31st, 2014

From Import Flat File Wizard, Edit the setting - Start Import At Row value as 3, that would skip/remove the first and second record and start importing from the third record.

Answer Question  Select Best Answer

If i enable select distince property in sorter transformation, on what basis the sorter tranformation removes the duplicate data

RaghuMVR

• Feb 4th, 2014

It will check all the column values of the records to identify the duplicates.

Karthik

• Jan 13th, 2014

The IS removes duplicates only if it is a row duplicate(entire row should be duplicate)

Answer Question  Select Best Answer

tannya

• Dec 15th, 2006

Fact tables always maintain the history records,and mostly consists of keys and measures,So after all teh dimension tables are populated,teh fact tables can be loaded.The load is always going to be a incremental load except for the first time which is a history load.

hanug

 Profile Answers by hanug Questions by hanug

• Dec 11th, 2006

HI:There are two ways u have to load fact table. 1. First time load2. Incremental load or delta loadIn both cases, u have to aggregate, get the keys of the dimentional tables and load into Fact.In case of increments, u use date value to pickup only delta data while loading into fact.Hanu.

Answer Question  Select Best Answer

Target Options for File Target type are FTP File, Loader and MQ.

There are no target options for ERP target type

Target Options for Relational are Insert, Update (as Update), Update (as Insert), Update (else Insert), Delete, and Truncate Table.

svivekananda

 Profile Answers by svivekananda Questions by svivekananda

• Jun 26th, 2010

Relationals db: UPDATE, INSERT, DELETE, TRUNCATEFlat file: Dir / filename

MANOJ KUMARPANIGRAHI

• Feb 21st, 2007

Target option for Flat file,relational file (update ,Insert)

Answer Question  Select Best Answer

Maping parameter represents a constant value that U can define before running a session.A mapping parameter retains the same value throughout the entire session. When u use the maping parameter ,U declare and use the parameter in a maping or maplet.Then define the value of parameter in a parameter file for the session. Unlike a mapping parameter,a maping variable represents a value that can change...

chandrarekha

• Sep 12th, 2007

Mapping parameter represents a constant value defined before mapping run.
Mapping reusability can be achieved by using mapping parameters.

Mapping variable represents a value that can be changed during the mapping run.
Mapping variable can be used in incremental loading process.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

You can use mapping parameters and variables in the SQL query, user-defined join, and source filter of a Source Qualifier transformation. You can also use the system variable $$$SessStartTime. The Inf...

Answer Question  Select Best Answer

Yes.Because reusable tranformation is not contained with any maplet or maping.

Prasad

• May 22nd, 2007

Hi, you can use the mapping parameters or variables in a reusable transformation. And when you use the xformation in a mapping, during execution of the session it validates if the mapping parameter that is used in the xformation is defined with this mapping or not. If not, the session fails.

mahesh4346

 Profile Answers by mahesh4346 Questions by mahesh4346

• Feb 2nd, 2007

But when one cant use Mapping parameters and variables of one mapping in another Mapping then how can that be used in reusable transformation when Reusable transformations themselves can be used among...

Answer Question  Select Best Answer

When a Joiner transformation occurs in a session, the Informatica Server reads all the records from the master source and builds index and data caches based on the master rows. After building the caches, the Joiner transformation reads records from the detail source and perform joins.

bneha15

 Profile Answers by bneha15 Questions by bneha15

• Apr 23rd, 2007

For version 7.x and above :When the PowerCenter Server processes a Joiner transformation, it reads rows from both sources concurrently and builds the index and data cache based on the master rows. The...

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

Specifies the directory used to cache master records and the index to these records. By default, the cached files are created in a directory specified by the server variable $PMCacheDir. If you overri...

Answer Question  Select Best Answer

Two sources should have primary and Foreign key relation ships. Two sources should have matching data types.

Yuvaraj

• Jan 10th, 2007

Both the sources must be from same database.

Surendra

• Apr 10th, 2006

Also of you are using a lookup in your mapping and the lookup table is small then try to join that looup in Source Qualifier to improve perf.RegardsSK

Answer Question  Select Best Answer

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

 Profile Answers by ASHOK1324 Questions by 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

 Profile Answers by rasmi Questions by 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 ...

Answer Question  Select Best Answer