October14/ 2018

Tally

Tally ERP 6.8

Tally ERP Tutorials... Coming Soon.. Course Contents : From basics to GSTR ...

March26/ 2017

Target Load Order/ Target Load Plan in Informatica

Target Load Order/ Target Load Plan in Informatica Target Load Order: Target load order (or) Target load plan is used to specify the order in which the integration service ...

March06/ 2017

InformaticaSenarios

Senario 9

Sending records to target tables in cyclic order  ...

March06/ 2017

InformaticaSenarios

Senario 7

Get top 5 records to target without using rank  ...

March06/ 2017

InformaticaSenarios

Senario 6

Sending alternate record to target ...

March06/ 2017

InformaticaSenarios

Senario 5

Sending first half record to one target and second half of record to another ...

March06/ 2017

InformaticaSenarios

Senario 4

Remove header and footer from your file  Solution:  We can remove ...

March06/ 2017

InformaticaSenarios

Senario 3

Retrieving first and last record from a table/file  ...

March06/ 2017

InformaticaSenarios

Senario 2

Separating duplicate and non-duplicate rows to separate tables. Solution: This ...

March06/ 2017

InformaticaSenarios

Senario 1

Convert single row from source to three rows in target. Solution : Let's assume ...

March06/ 2017

InformaticaSenarios

Senario 32

Error Handli ...

March06/ 2017

InformaticaSenarios

Senario 31

Unit Testi ...

March06/ 2017

InformaticaSenarios

Senario 30

SCD Type3  ...

March06/ 2017

InformaticaSenarios

Senario 29

SCD Type2  ...

March06/ 2017

InformaticaSenarios

Senario 28

SCD TYPE1  ...

March06/ 2017

InformaticaSenarios

Senario 27

Constraint Based Loading ...

March06/ 2017

InformaticaSenarios

Senario 26

Column to Rows Conversion   ...

March06/ 2017

InformaticaSenarios

Senario 25

Rows to column conversion         ...

March06/ 2017

InformaticaSenarios

Senario 24

Concurrent execution of a workflow. ...

March06/ 2017

InformaticaSenarios

Senario 23

Separate even odd records &nbs ...

March06/ 2017

InformaticaSenarios

Senario 22

Demonstrate Incremental Aggregation. ...

March06/ 2017

InformaticaSenarios

Senario 21

Demonstrate Incremental load. ...

March06/ 2017

InformaticaSenarios

Senario 20

How to load multiple files with different structure. ...

March06/ 2017

InformaticaSenarios

Senario 19

Add custom message to session log file. ...

March06/ 2017

InformaticaSenarios

Senario 18

Count the no of vowel present in emp_name column ...

March06/ 2017

InformaticaSenarios

Senario 17

Insert and reject records using update strategy ...

March06/ 2017

InformaticaSenarios

Senario 16

Minus operation on flat file ...

March06/ 2017

InformaticaSenarios

Senario 15

sending data one after another to three tables in cyclic order  ...

March06/ 2017

InformaticaSenarios

Senario 14

Removing '$' symbol from salary column  ...

March06/ 2017

InformaticaSenarios

Senario 13

Using mapping parameter and variable in mapping ...

March06/ 2017

InformaticaSenarios

Senario 12

Produce files as target with dynamic names  ...

March06/ 2017

InformaticaSenarios

Senario 11

Lead and Lag in informatica leve ...

March06/ 2017

InformaticaSenarios

Senario 10

Concatenation of duplicate value by comma separation  ...

March06/ 2017

InformaticaSenarios

Senario 8

Extracting every nth row  ...

January14/ 2017

OracleSQL

When Composite Keys are required ?

Many of us knew about the primary key importance. A Primary key is unique identifier for the rows in the table, so by using primary key we can easily find the unique row from a ...