IT Pandora (ETL,DB,UNIX,AWS,NodeJS,Github etc.)

Source Qualifier is Active Transformation Source Qualifier is connected transformation. It should be there in pipeline. This is default transformation which comes along with source instance when you drag and drop into mapping area.But there is some exceptional case with XML and COBOL sources. This is mandatory transformation to read data from sources and it converts the source data types to the informatica native data types. So, you should not alter the data types of the ports in the source qualifier transformation. If we are not using Push Down Optimization, then every port of source qualifier should have link from source instance. Otherwise, workflow will fail. If we are using Push Down Optimization, then at-least one port of source qualifier should have link from source instance. Otherwise, workflow will fail. Source Qualifier Properties: Below are the Source qualifier properties and there are enable when we are using tables as sources. In case of files as source, th...

Unlike the other databases Teradata and Oracle, We need to get the view definition in POSTGRE database from pg_views table. Query: SELECT definition FROM pg_views WHERE viewname='<View_name>'; The above query will give us the complete view definition. To see only columns and it's datatypes, we can use below: \d+  <view_name>;

If there is a requirement to load data into target tables with the same workflow by passing different values for parameters, we knew that we can change parameter file every time to pass new value to parameters. But this requires manual intervention. This manual changes will not be encouraged in production environment for any client. To avoid this manual changes to parameter files every time before you run for particular set, We can use "Configure Concurrent Execution" option from workflow properties. To do this, we need to create different parameter files as per the requirement. To enable concurrent execution, go to EDIT WORKFLOW. We can see the option "Configure Concurrent Execution". Enable this option.Once enabled, one button "Configure Concurrent Execution....." will be enabled. Click on this button and you will get another dialog box. Here, we need to pass parameter file details which we were created earlier. Thank you...And ...

It's been long time, since the last post. Let's get to know about mongo database. So mongo is one of the front runners in nosql databases. Nosql databases do not adhere to rules and principles to standard relational databases. So coming to Mongo it a document oriented database which is written in C++.   Mongo is an open source database. It is simple to install more of a plug and play type.   Once you are done with the mongo installation To start the mongo server in our local machine. Execute the command in command terminal   C:\MongoDB\bin\mongod.exe --config="C:\MongoDB\mongo.config"   To start the client in our local machine execute the following command in the command terminal   C:\MongoDB\bin\mongo   Upon executing we can see the following screen      By default there will be a test database created in our mongo database. So it will be connected to that particular database.   We can create our ...