Read Best Answer

Editorial / Best Answer

gazulas  

 Profile Answers by gazulas Questions by gazulas

• Member Since Jan-2006 | Jan 29th, 2006

---

if supported by the database  bulk load can do the loading faster than normal load.(incremental load concept is differnt dont merge with bulk load, mormal load)

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 14th, 2011

It's totally depends upon the requirement. generally bulk load is faster caz it won't write the data to database logs so we can't do session recovery where as in normal load it is very slow comparing to bulk but the advantage is we can do session recovery..

vikota

 Profile Answers by vikota Questions by vikota

• Apr 12th, 2011

 Incremental load: Incremental means suppose today  we processed 100 records ,for tomorrow  run u need to extract  whatever the records inserted newly and  updated after ...

Improve Answer

Joe

• Feb 7th, 2013

ECHO OFF This automates the informatica workflow run using pmcmd ECHO c:informaticaserverinpmcmd startworkflow -u username -p password -s server:host -f Folder -wait MYWORKFLOW

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Feb 11th, 2008

C:-->Program Files-->Informatica PowerCenter 7.1.3-->Server-->bin-->pmcmd.exe

Answer Question  Select Best Answer

Chetan

• Mar 2nd, 2018

What if the we have
1,100,Banglore
2,100,chennai
3,100,Mysore
1,101,bangalore
2,101,Kol

Your query will retun 2,3 and we will get
2,100,chennai
3,100,Mysore
2,101,Kol as output

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Jul 9th, 2012

Sorry for my previous post. I missed a bit of question.

select * from where version in (select max(version) from group by id, loc_no)

Answer Question  Select Best Answer

What transformation do you use to convert source column into target rows? Explain

vijayant.sanjay

 Profile Answers by vijayant.sanjay Questions by vijayant.sanjay

• Sep 7th, 2011

Normalizer is basically used to convert rows to columns. I don't think alone normalizer is sufficient to convert columns into rows. In certain scenario you use this sequence of t/f to convert columns ...

Ishaan_Kulshrestha

 Profile Answers by Ishaan_Kulshrestha Questions by Ishaan_Kulshrestha

• Apr 14th, 2010

Hi Sahan,Please let me know how aggregator is used here. I think Aggregator is required when we denormalise data and here our requirement is to Normailse the data.Please correct me if I am wrong. Thanks

Answer Question  Select Best Answer

The data movement mode depends on whether Informatica Server should process single byte or multi-byte character data. This mode selection can affect the enforcement of code page relationships and code page validation in the Informatica Client and Server.a) Unicode - IS allows 2 bytes for each character and uses additional byte for each non-ascii character (such as Japanese characters)b) ASCII - IS...

Read Best Answer

Editorial / Best Answer

Answered by: purushotham

• Aug 9th, 2005

---

the two types of modes are: 
1) Normal Mode in which for every record a separate DML stmt will be prepared and executed 
 
Bulk Mode in which for multiple records DML stmt will be preapred and executed thus improves performance.

amolrenose

 Profile Answers by amolrenose Questions by amolrenose

• Sep 18th, 2011

Data Movement Modes

1. ASCII mode :- Single byte of data is processed.
2. UNICODE mode :- Two bytes of data is processed.

Data Loading Modes

1. Normal Mode :- Commit is executed after 10000 records (default).
2. Bulk Mode :- Commit is executed after all records have been loaded.

sivakp

 Profile Answers by sivakp Questions by sivakp

• Mar 13th, 2011

1. ASCII mode2. UNICODE mode

Improve Answer

Read Best Answer

Editorial / Best Answer

Rajsuni  

 Profile Answers by Rajsuni Questions by Rajsuni

• Member Since Apr-2011 | Apr 1st, 2011

---

 Informatica Architecture :
            
   client tools-
                  Repositoy Manager->  Pc Designer->    WFManager->           WFMonitor       
                            |                               |                          |                                |
              (creat,mdify,del-folders,    (src&Tar def,         (create tasks             (display
              privilages& access RS)     mapings,maPlets)connect to work flow) reult/output)
   ---------------------

   Powercenter tools--
                   PC service   <--------------------->Repository Database
                          |
                          |
         <-------> PC Server<---->

here: Pc-PowerCenter.

venkat m

• Sep 20th, 2011

Informatica Architecture : client tools- Repositoy Manager-> Pc Designer-> WFManager-> WFMonitor | ...

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 15th, 2011

When we install the informatica powercenter, the following components gets ionstalled 1) powercenter clients 2) Integration service 3) powercenter Repository service 4) powercenter Repository 5) power...

Improve Answer

Hi Folks,

I have scenario like, I have ten flat files to be loaded in to target but I need to load file names in to a table in mapping level. I think we can do achieve though TC transformation. Unfortunately I did not get though.. Please advise how to implement the logic. ( I need to capture in mapping level only).

This question has been asked one of the interviews.

BRAHMAIAH

 Profile Answers by BRAHMAIAH Questions by BRAHMAIAH

• Dec 30th, 2014

Hi folks, If all files have structure then we go for Indirect file method.we set this property at session level by selecting the source def. After define of the source def at mapping level just do...

Mayur

• Jun 23rd, 2014

Got to flat file properties and there you will find one icon Add FileName column to this table just click on that option and you can able to add currently processing file. Thank you

Answer Question  Select Best Answer

How to format phone number 9999999999 into (999)999-9999 in informatica

Vids

• Aug 13th, 2013

It can be achieved using the IDQ tool where u can set the standard format . EVen I am not sure how exactly

sreenu

• Dec 4th, 2011

Using the CONCAT (||) operator and SUBSTR function in the expression transformation.

Answer Question  Select Best Answer

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  

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

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

Improve Answer

Normal (Default) Master outer Detail outer Full outer

ravi ranjan

• Jul 22nd, 2016

Joiner transformation having four types
1 Normal join
2 Master outer join
3 Detail outer join
4 Full join

Kiran Ghatage

• Nov 15th, 2014

Look into following mappings
https://community.informatica.com/solutions/developer_client_full_outer_join

https://community.informatica.com/solutions/developer_client_self_join_using_joiner

Answer Question  Select Best Answer

sathish

• Apr 6th, 2007

Ok we will refer development document , Could you teach me how to write test cases for unit testing in development document before development and give me an example to sample test cases.

Gopalakrishnan Kannan

• Dec 21st, 2006

Hi,To test the mapping, 1. Prepare mapping document. This mapping document explains start to finish of the entire transaction. This document shld contains each column level transformation logic from s...

Answer Question  Select Best Answer

Rajarao marisa

• May 31st, 2012

Ok its not good work environment by using multiple filter t/r usage Any way by using multiple filter we can load rejected rows also SD-->SQ-->fltr(condition(true)(eg:deptno=10)---->loaded into one tar...

srinuraj

 Profile Answers by srinuraj Questions by srinuraj

• May 31st, 2010

You can use filter transformations to filter rows. Filter transformations passes rows to next transformation which rows met the condition. But it cannot pass rows which rows doesn't meet the condition...

Answer Question  Select Best Answer

How to find out duplicate records using aggregator. Pls explain with example. What is the need for placing joiner after aggregator. I just tried like the following:Count the records and group by all the columns. if the count=1 then it will be a valid record. what to do if the count >2.means file contains duplicate records.Why we need to use joiner after aggregator?

VISHNU VARDHAN

• Nov 17th, 2015

Use HAVING Condition in SELECT clause, You can write code like below to test, if it is greater than one then it is duplicate otherwise Unique.

Code
 

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Aug 7th, 2012

Hi, Its similar to the SQL query, SELECT * FROM ,,.... FROM TABLE_NAME GROUP BY ,,..... HAVING COUNT(*)=1 Similarly in Informatica Aggregator transformation, select group by for all the columns and...

Answer Question  Select Best Answer

What is the difference between STOP and ABORT options in Workflow Monitor?

Satish

• Mar 4th, 2014

STOP ensures current session activity / threads on Informatica server are complete and ends the workflow.
ABORT kills current session activity / threads on Informatica server irrespective of its state and ends the workflow.

Sudha Rani

• Nov 6th, 2012

If we have to do stop it will stop that step only.again we have to start the workflow then that time it will start which step u have to stop that step only it start run the workflow then abort says we...

Answer Question  Select Best Answer

How can we receive source as flat file in informatica, from where we get this flat file?

sri

• Jun 18th, 2017

We get flatfile from source to target, which is in file format like MS-Word, etc

Anil

• Jun 22nd, 2016

To explain it clearly we have to know the concept of using FTP. Consider a banking project, the product owner gives all data to production team and not to developer, the 3rd party team gives another d...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: srinvas vadlakonda

• Sep 28th, 2006

---

Source name
Database location
Column names
Datatypes
Key constraints

srikanth

• May 11th, 2022

Column names

Sumithav29

 Profile Answers by Sumithav29 Questions by Sumithav29

• Jun 12th, 2009

ODBC data source, username, owner name, password. Once the connection is established, select the table.

Improve Answer

hanimi

 Profile Answers by hanimi Questions by hanimi

• Apr 28th, 2011

Bulk load the dwh server bypass the data to the target, in that we have session performance improves.in normal load data moves the database log file.

Ray

• Mar 22nd, 2006

Also remember that not all databases support bulk loading. and bulk loading fails a session if your mapping has primary keys

Answer Question  Select Best Answer

Ruhi

• Feb 4th, 2016

The header or footer can be created in the target using the property "append if exist" Depending on what you need in the header / footer and target data create our mapping. Example 3 flows of data So...

lakshmi

• Nov 7th, 2012

Hi..
As uma told...she is rite,but may i know how to create footer in a flatfile

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: swati

• Nov 5th, 2005

---

star schema consists of single fact table surrounded by some dimensional table.In snowflake schema the dimension tables are connected with some subdimension table.

In starflake  dimensional ables r denormalized,in snowflake dimension tables r normalized.

star schema is used for report generation ,snowflake schema is used for cube.

The advantage of snowflake schema is that the normalized tables r easier to maintain.it also saves the storage space.

The disadvantage of snowflake schema is that it reduces the effectiveness of navigation across the tables due to large no of joins between them.

halgai

 Profile Answers by halgai Questions by halgai

• Oct 8th, 2007

Snowflakes are an addition to the Kimball Dimensional system to enable that system to handle hierarchial data.  When Kimball proposed the dimensional data warehouse it was not first recogonized t...

Richard

• Feb 2nd, 2006

It depends upon the clients which they are following, whether snowflake or star schema.

Improve Answer

Read Best Answer

Editorial / Best Answer

deepthi_97  

 Profile Answers by deepthi_97 Questions by deepthi_97

• Member Since Sep-2009 | Sep 23rd, 2009

---

Cobol files and we use normalizer transformation

deepthi_97

 Profile Answers by deepthi_97 Questions by deepthi_97

• Sep 23rd, 2009

Cobol files and we use normalizer transformation

Prabu

• Jun 22nd, 2007

The mainframe files are Used as VSAM files in Informatica by using the Normaliser transformation

Improve Answer